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