Types of Roles

Role is nothing but collection of privileges.

There are 2 types of roles :

                1.predefined roles

                2.DBA created roles

Examples of predefined roles :

                connect, resource, dba, exp_full_database, imp_full_database, delete_catalog_role, select_catalog_role.....etc

 

SQL> create role developer_user;

SQL> grant create table, create index, create session to developer_user;

SQL> create user scott identified by tiger default tablespace hrms_ts role developer_user;

 

Whatever the roles that we create, we assign them to database users. Role can be assigned to a role.

 

"select_catalog_role" grants a select privilege on all data dictionary views / tables.