Editing authorization issue in SAS Visual Analytics - Unable to lock object

[myleha]

Hi all,

I'm using SVA 8.5 and I'm editing user authorization to data tables. However, I encountered this issue. Does anyone have any experience in solving this? 

Any help is much appreciated.

Thank you in advance!

[Madelyn_SAS]

Please see the topic Inability to Modify Access in the SAS Viya 3.5 Administration documentation. 

[swapnil9099]

Hi @myleha Im facing the exact same issue. I tried reading through the documentation but did not find any major insights.

Were you able to resolve this issue, if yes, please let me know the fix.

Thanks.

[Madelyn_SAS]

Try unloading the table from memory. Then, select the table from the Data Sources tab and try to open Edit Authorization. 

[swapnil9099]

@Madelyn_SAS  Thanks, this has helped, now I can edit authorization on the physical table.

Going forward, should I edit authorization directly on a physical table or is it preferred to do it on an in-memory table?

[Madelyn_SAS]

The permissions should be set on the sashdat table, not the in-memory table. 

This is from the documentation: 

• If you get the following error: "The access controls for table {name} are being blocked by a loaded table of the same name", select or specify a source file (for example, tableA.sashdat), not an in-memory table. See Application and Persistence of CAS Access Controls.