topic Re: Change permissions on all tables within a library in Administration and Deployment

Change permissions on all tables within a library

DG1984 — Wed, 26 Jun 2019 10:04:59 GMT

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

Re: Change permissions on all tables within a library

PaulHomes — Thu, 27 Jun 2019 13:23:19 GMT

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&docsetVersion=9.4&locale=en