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