Grant access of Db2 table created by me to other user



IBM's flagship relational database management system

Grant access of Db2 table created by me to other user

Postby gouravar » Fri Nov 03, 2017 3:38 pm

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.
gouravar
 
Posts: 7
Joined: Tue Jun 12, 2012 10:36 pm
Has thanked: 3 times
Been thanked: 0 time

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

Postby enrico-sorichetti » Fri Nov 03, 2017 3:43 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post