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

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

myleha — Mon, 17 May 2021 03:33:12 GMT

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!

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

Madelyn_SAS — Wed, 30 Jun 2021 14:36:47 GMT

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

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

swapnil9099 — Thu, 20 Oct 2022 16:36:05 GMT

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.

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

Madelyn_SAS — Thu, 20 Oct 2022 18:10:20 GMT

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

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

swapnil9099 — Fri, 21 Oct 2022 05:10:08 GMT

@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?

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

Madelyn_SAS — Fri, 21 Oct 2022 13:05:37 GMT

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.