Regina and Kristen are manager level users : Roles « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. Roles
SQL> CREATE ROLE manager;

Role created.

SQL>
SQL> CREATE USER regina identified by regina;

User created.

SQL> CREATE USER kristen identified by kristen;

User created.

SQL> GRANT CONNECT TO regina, kristen;

Grant succeeded.

SQL> GRANT manager TO regina, kristen;

Grant succeeded.

SQL>
SQL> drop user regina;

User dropped.

SQL> drop user kristen;

User dropped.

SQL>
SQL> drop role manager;

Role dropped.








36.7.Roles
36.7.1.Roles
36.7.2.Creating Roles
36.7.3.Granting Privileges to Roles
36.7.4.Granting Roles to a User
36.7.5.Assign Role to User
36.7.6.Checking Roles Granted to a User
36.7.7.Checking System Privileges Granted to a Role
36.7.8.Checking Object Privileges Granted to a Role
36.7.9.Assign CONNECT and RESOURCE Roles
36.7.10.Default Roles
36.7.11.Revoking a Role
36.7.12.Revoking Privileges from a Role
36.7.13.Dropping a Role
36.7.14.Regina and Kristen are manager level users
36.7.15.Rich and Brad are maintenance level users
36.7.16.Unassign Role
36.7.17.Drop Role
36.7.18.Assign object privileges to roles
36.7.19.Unassign Role from User
36.7.20.Output session roles from procedure
36.7.21.Query user granted roles