WITH ADMIN OPTION and WITH GRANT OPTION
562851Mar 26 2007 — edited Mar 26 2007in referenece to
http://www.remote-dba.net/t_ault_76_revoke_system_priv.htm
When system privileges are passed to others using the WITH ADMIN OPTION, revoking the system privileges from the original user will not cascade.
Q 1) If there is chaining as a ->b (with admin) -->c (with admin) -->d........
if
revoke <system privileges >..... from b
will revoke all priveleges from c/d too.
2 )how to revoke privileges from d in this case if a wants to revoke priv. from b.
3)How to revoke object privileges from d if With Grant option is Chained?
Manish