In Oracle, if the current user tries to revoke all his permissions, what'll happen?
For example, if I'm a user(John) created with WITH GRANT OPTION - can I revoke my permissions?
In Oracle, if the current user tries to revoke all his permissions, what'll happen?
For example, if I'm a user(John) created with WITH GRANT OPTION - can I revoke my permissions?
Any user with the ADMIN OPTION
for a system privilege or role can revoke the privilege or role from any other database user or role. The revoker does not have to be the user that originally granted the privilege or role. Users with GRANT ANY ROLE
can revoke any role.
Reference