View previous topic :: View next topic
|
Author |
Message |
feng hao
New User
Joined: 26 Mar 2008 Posts: 44 Location: China
|
|
|
|
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 |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Hi,
I think only way is to revoke the complete access and then grant select access without "with grant" option. |
|
Back to top |
|
|
VinayCM
New User
Joined: 06 Nov 2007 Posts: 36 Location: Bengaluru
|
|
|
|
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 |
|
|
|