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   ... View more

@DG1984 wrote: Thanks for the paper, I found it online yesterday and found it useful.  I am using explicit and not implicit because the tables I am querying have a lot of data and I only want a small section of that data.   Thanks @DG1984 The SAS Access engine will try and push as much of the processing to the database as it manages. Use the following set of SAS options at the beginning of your code. This will then show you in the log what actually gets executed on the database side and what on the SAS side. options sastrace=',,,d' sastraceloc=saslog nostsuffix; For your code here there is a high chance the access engine will be able to fully convert your SQL to the database flavour and though all processing will happen in-database.   ... View more

Will definitely give this a try and compare with a few others I have been given!! Thanks All for help! ... View more

LIBNAME statement has an option FILELOCK something like . Maybe could apply to your scenario . ... View more