Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Revoke GRANT & ADMIN option

545090Nov 27 2006 — edited Nov 27 2006

Hi,

How can I revoke admin option and/or grant option from a user.?

Suppose I have granted a database user "ABC" through SYS user.
Grant all on user.table_name to ABC with grant option/ with admin option.

How can I revoke GRANT option or ADMIN option from "ABC" without revoking any privilege from him on ABC?

Please help

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 25 2006

Added on Nov 27 2006

#general-database-discussions

10 comments

726 views