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
