Granting Roles to a User

You grant a role to a user using GRANT. The following example grants the secondRole role to tom:


CREATE ROLE secondRole IDENTIFIED by password;
GRANT SELECT, INSERT, UPDATE, DELETE ON employee TO firstRole;
GRANT SELECT, INSERT, UPDATE, DELETE ON products TO firstRole;
GRANT firstRole TO secondRole;

GRANT secondRole TO tom;
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: