Page 1 of 1

Grant access of Db2 table created by me to other user

PostPosted: Fri Nov 03, 2017 3:38 pm
by gouravar
Hello everyone,

I want to give access of 1 table created by me to one of my colleagues.

To do this I have executed below statement in SPUFI to grant access to my colleague.

GRANT ALL ON TABLE SCHEMANAME.TABLENAME TO USERID1 WITH GRANT OPTION ;

Command executed successfully with return code 0 but my colleague didn't get access to the table.

Could anyone please suggest what is the problem here.

Thanks in advance.

Re: Grant access of Db2 table created by me to other user

PostPosted: Fri Nov 03, 2017 3:43 pm
by enrico-sorichetti
I want to give access of 1 table created by me to one of my colleagues.


playing around with permission and access right should be done ONLY with Your security support approval and advice

not doing so might be cause for lawful termination

topic locked