BookmarkSubscribeRSS Feed
DG1984
Fluorite | Level 6

I am using SAS Management Console 9.4, I have created an oracle connection and set up a library within Data Library Manager, within this library there are 100+ views when setting access to read for all sasusers on the library this does not change the table permissions, the only way I have managed to do this is by right clicking on each table and changing the permissions. Would anyone know of a quick easier way to do this?

 

Thanks

1 REPLY 1
PaulHomes
Rhodochrosite | Level 12

In the SAS 9.4 metadata model permissions for tables do not inherit from the library they are contained in but instead from the folder they are contained in. To set permissions consistently across a large number of tables, apply the permissions to one of the parent folders the tables are contained in. See https://documentation.sas.com/?docsetId=bisecag&docsetTarget=p0eqebtrv1qhzhn1qje3kytr5kcr.htm&docset...

 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1599 views
  • 4 likes
  • 2 in conversation