topic Re: How to grant access to a table built in SAS in SAS Programming

How to grant access to a table built in SAS

Tater_Salad — Fri, 04 Jan 2019 20:28:59 GMT

Hi I have the following table called Cohmon stored in a Library called JANUS (shown below).

How do I grant Access to all for the COHMON table?

The Library was created as so:

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

Is it something like:

GRANT ALL PRIVILEGES ON SCHEMA "JANUS" TO USERS;

Re: How to grant access to a table built in SAS

SuryaKiran — Fri, 04 Jan 2019 21:14:40 GMT

Hello,

You have that dataset stored in Unix/Linux directory. You might need to set directory level permissions here (using Putty or similar ).

Check this link to learn about the permissions http://linuxcommand.org/lc3_lts0090.php

Re: How to grant access to a table built in SAS

SASKiwi — Fri, 04 Jan 2019 21:38:50 GMT

You appear to be assuming that permissions on SAS tables work the same as in relational databases. They don't as SAS is not a relational database. There are two ways to control table permissions. One is through folder/directory permissions at the OS level, as @SuryaKiran has described. The other way is through SAS metadata, although this only applies if you define your library in SAS metadata via SAS Management Console, not with a LIBNAME statement.

Re: How to grant access to a table built in SAS

Tater_Salad — Fri, 04 Jan 2019 22:39:12 GMT

That makes total sense however I pulled this up on a SAS Document page on Granting privileges:

GRANT and DENY Statements

Enables you to give privileges to a specific user or all users to perform actions on objects. When submitting a grant, revoke, or deny DDL, surround all identifiers in quotation marks, including table and column names.

Note: CREATE DSN and ADMINISTER privileges cannot be granted or denied for the PUBLIC and USERS groups.

Syntax

GRANT | DENY { {"objectpriv" |"containerpriv" |

"serverpriv" [,...] } |

ALL [ PRIVILEGES ] }

[ ON { SCHEMA "schemaname" | CATALOG "catalogname" |

[DATA] SERVICE "servicename" | DSN "dsnname" | SERVER } ]

TO { "authid" | PUBLIC | USERS } [, ...]

[ AS ADMINISTRATOR ]

I think my issue with this statement was, I was unable to figure out what they meant by SCHEMA, CATALOG, SERVICE, and DSN and how to map it to the structure I showed you in my first frame.

[ ON { SCHEMA "schemaname" | CATALOG "catalogname" |
 [DATA] SERVICE "servicename" | DSN "dsnname" | SERVER } ]

So you know if this GRANT Statement applies to my issue at all?

Here's the link to the page:

http://support.sas.com/documentation/cdl/en/fedsrvmgrag/65976/HTML/default/viewer.htm#n00l5zxf3olrthn1017cju0x0890.htm

Re: How to grant access to a table built in SAS

SASKiwi — Sat, 05 Jan 2019 02:45:24 GMT

That relates to the SAS Federation Server which can be used to apply permissions to third-party relational databases only, not to SAS data.

Re: How to grant access to a table built in SAS

Reeza — Sat, 05 Jan 2019 02:54:22 GMT

So your data is on a server and you're trying to add this to a registered library? And you have the appropriate privileges to do so?

Re: How to grant access to a table built in SAS

Tater_Salad — Mon, 07 Jan 2019 15:58:14 GMT

Yes

Re: How to grant access to a table built in SAS

Tater_Salad — Tue, 08 Jan 2019 16:37:18 GMT

Here's an update:

Turns out it looks like the person requesting this info is wanting to GRANT Access on a Neteeza object.

So it would be something like:

proc sql;

create table RSYNC.target as
select * from WORK.SALES_TBL where 1 = 0;

insert into RSYNC.target 
select * from WORK.sales_tbl_tst2
;

GRANT INSERT, SELECT, DELETE ON RSYNC.target TO PUBLIC;


quit;

The trouble is when I run SAS with this GRant statement I get the following message:

NOTE: The GRANT statement is not implemented in PROC SQL.

Now this message is in green so it's not coming off as an error. But from the context of the message I'm not sure if GRANT privileges have actually been granted.

I've looked for Neteeza DBA table that'll tell me what privileges an object has and but, unlike Oracle which has DBA Tables and views for,..., you name it,..., the DBA tables in Netezza are somewhat limited.

Does anybody know if this is the way to go or if there's a more accurate way to set the native database privileges in SAS for Netezza?

I think I'm on the right track but I need to be sure.

Does anyow if this is the way to