Please send your Questions & Answers or Feedback to ""

Please send your Questions & Answers or Feedback to ""

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.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter