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 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

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