Today we are going to have look at Role in Oracle database. It is the most important part of Oracle database. User Privileges and Roles is the most common task that is performed by Oracle DBA. With roles and privileges, we can easily point out which user has what responsibilities in databases.

 

 

Let’s start with roles in Oracle.

Creating a Role:

Assign Privilege to a role:

Assign More Privilege to the role:

Add Another Layer To The Heirarchy:

Assigning Role to user:

Granting System Priviledge:

Revoke Role From a User:

Drop a Role:

Obtaining Role Information:

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

Thanks for giving valuable time to add new gems to Oracle’s treasure.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.