How to identify who is the schema with DBA privilege
- From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Jan 2012 18:39:24 -0200
Hi,
I would like to know how to identify who has DBA privilege.
If I do : SELECT * FROM user_ROLE_PRIVS
I can see my privileges.
There is no ALL_ROLE_PRIVS and DBA_ROLE_PRIVS .
Is there another view or table that can say it to me ?
Note: I need to know in both situations:
With DBA schema connected and not DBA schema connected.
Regards
Eriovaldo
--
//www.freelists.org/webpage/oracle-l
Other related posts:
