Granting permissions on the SAS Enterprise Guide.

Tater_Salad — Wed, 09 Jan 2019 18:47:12 GMT

We're using SAS EG 7.13 HF1 (7.100.3.5419) (64-bit)

I want to Grant privileges to a SCHEMA on a SAS server.

I'm trying to figure out the where I actually put this Grant statement.

Do I put the statement within the [proc sql; ---quit;] block?

Also, if I'm trying to grant privileges to all the objects in the below folder how am I going to write that GRANT statement.

libname JANUS '/sasdata/mids_output02/rjs/';

I get an error when I try:

GRANT SELECT ON SCHEMA "JANUS" TO USERS;

Below is the Project tree I'm basing this off. What am I missing?

Re: Granting permissions on the SAS Enterprise Guide.

SASKiwi — Wed, 09 Jan 2019 20:17:37 GMT

This looks like a followup to your earlier post:

https://communities.sas.com/t5/SAS-Programming/How-to-grant-access-to-a-table-built-in-SAS/m-p/524782#M142727

As already mentioned, a SAS library is not a relational database. There is no concept of a SCHEMA at all. When you run your LIBNAME statement you are creating a pointer to an OS folder where SAS datasets are stored as specially-formatted OS files. The pointer you create, in your case JANUS is what is called a library reference or LIBREF for short.

You can't use SQL permissions statements on a SAS library. Instead permissions are controlled at the OS level. If a user has read permissions on your Unix folder - /sasdata/mids_output02/rjs - then they will be able to assign the LIBNAME and read the data. If you are not familiar with the Unix command to set folder permissions (chmod I believe) then talk to your SAS administrator.

To understand basic concepts like what is a SAS data library reading the documentation is helpful: https://documentation.sas.com/?docsetId=lrcon&docsetTarget=n0h2sjhthqhfogn1h6rxh3dvaiwj.htm&docsetVersion=9.4&locale=en

topic Re: Granting permissions on the SAS Enterprise Guide. in SAS Enterprise Guide

Granting permissions on the SAS Enterprise Guide.

Re: Granting permissions on the SAS Enterprise Guide.