Creating a Role:

create role clerk;

 

Assign Privilege to role:

grant create session,create table to clerk;

Assign More Priviledge to the role:

SQL>Create table test(id number); 

SQL>grant select,insert,update on test to clerk;

 

Add Another Layer To The Heirarchy:

SQL>CREATE ROLE manager;

SQL> GRANT clerk TO manager;

SQL> GRANT DELETE ON test TO manager;

 

Assigning Role to user:

GRANT clerk TO liton;

GRANT manager TO arif;

 

Granting System Priviledge:

GRANT CREATE SESSION to manager WITH ADMIN OPTION;

 

Revoke Role From a User:

REVOKE manager FROM arif;

Drop a Role:

DROP ROLE manager;

 

Obtaining Role Information:

• DBA__ROLES
• DBA_ROLES_PRIVS
• ROLE_ROL_PRIVS
• DBA_SYS_PRIVS
• ROLE_SYS_PRIVS
• ROLE_TAB_PRIVS
• SESSION_ROLES