Topic : Role Management

What are roles? How can we implement roles?


Answer :

Roles are the easiest way to grant and manage common privileges needed by different groups of database users.

Show Answer Discuss

How to create role?


Answer :

SQL> Create role select_data_role;
SQL> Grant select on emp to select_data_role;

Show Answer Discuss

How to create role with password?


Answer :

CREATE ROLE role IDENTIFIED BY password

Show Answer Discuss

How to create role authorised by the OS?


Answer :

ALTER ROLE role IDENTIFIED EXTERNALLY

Show Answer Discuss

How to create role authorised by theDirectory Service?


Answer :

ALTER ROLE role IDENTIFIED GLOBALLY

Show Answer Discuss