IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to revoke the "with grant option" only?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
feng hao

New User


Joined: 26 Mar 2008
Posts: 44
Location: China

PostPosted: Thu May 12, 2011 6:14 pm
Reply with quote

User Tom is authorized "select on table TTT with grant option", and now I would like to revoke "with grant option" from it and leave select privilege only.

The question is that is it possible that remove the "with grant option" only without remove the whole of it and then grant select to it again?

I have tried to do it and also looked up for the reference, however, all failed.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu May 12, 2011 6:41 pm
Reply with quote

Hi,

I think only way is to revoke the complete access and then grant select access without "with grant" option.
Back to top
View user's profile Send private message
VinayCM

New User


Joined: 06 Nov 2007
Posts: 36
Location: Bengaluru

PostPosted: Tue May 17, 2011 5:34 pm
Reply with quote

Execute the below queries, I hope it should solve your problem.

REVOKE SELECT
ON TABLE TTT FROM <id of which access u want to revoke>

BY <your id>;
COMMIT;

GRANT SELECT
ON TABLE TTT
TO <id for which u want to give access>;
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts SCOPE PENDING option -check data DB2 2
No new posts PuTTY - "User is not a surrogate... IBM Tools 5
No new posts OUTFIL with SAVE option DFSORT/ICETOOL 7
No new posts CICS vs LE: STORAGE option CICS 0
No new posts Newbie Stuck on "Duplicate Datas... TSO/ISPF 5
Search our Forums:

Back to Top