LuckyLucks
asked on
grant select permissions on created table
Hi:
I have created a table as follows:
libname A db2 database=D SCHEMA=B user=&userid password=&userpw;
proc sql;
create table A.MTH(BULKLOAD=YES,DBCOMMI T=1000000, INSERTBUFF =10,
BL_DATAFILE='/myfolder/tes t.dat',BL_ OPTIONS='c ompound=7 norowwarnings')
as select *
from X.T1;
grant select on A.MNTH to user1,user2 <------want to accomplish this!!
quit;
I have created a table as follows:
libname A db2 database=D SCHEMA=B user=&userid password=&userpw;
proc sql;
create table A.MTH(BULKLOAD=YES,DBCOMMI
BL_DATAFILE='/myfolder/tes
as select *
from X.T1;
grant select on A.MNTH to user1,user2 <------want to accomplish this!!
quit;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.