Revoking a Role

You revoke a role using REVOKE.


REVOKE secondRole FROM tom;

Revoking Privileges from a Role


REVOKE ALL ON products FROM firstRole;
REVOKE ALL ON employee FROM firstRole;
Home »
Oracle »
User, Privilege, Role » 

Roles:
  1. Creating Roles
  2. Granting Roles to a User
  3. Checking Roles Granted to a User
  4. Checking System Privileges Granted to a Role
  5. Checking Object Privileges Granted to a Role
  6. Default Roles
  7. Revoking a Role
  8. Dropping a Role
Related: