Being Oracle DBA we are aware that Oracle provides lots of views and parameters which helps DBA a lot to maintain the database. In this article, we are going to know about the user’s privilege. We may find that different users have different permissions in the database.

Let’s have look at the query which we use to find users with DBA privilege.

SQL> select * from dba_role_privs where granted_role='DBA';

GRANTEE                   GRANTED_ROLE        ADMIN_OPTION        DEFAULT_ROLE
------------------------- --------- ------------------------------------------- --------- -
SYS                        DBA                     YES             YES
SYSTEM                     DBA                     YES             YES

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.