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

Yes ... View more

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

Hi We're using SAS EG V 7.13 HF1 (7.100.3.5419) (64-bit). I'm running a script from a local Windows directory. I have a file called sas_pwd.sas I'm referencing in the command: %include 'sas_pwd.sas'; However it's not being picked up by my SAS script. I'm getting the following error message. 24 %include 'sas_pwd.sas'; WARNING: Physical file does not exist, /sasdata/work/sasuser/rolap/sas_pwd.sas. ERROR: Cannot open %INCLUDE file sas_pwd.sas. Which is in my home directory for SAS. So how can I either have the script point to the file on my local machine where it's in the directory say: c:\mydir\me or how can I have the script find the file ion the Linux server where it's in say /home/rolap/? If you can answer to both that'd be a bonus. ... View more