How to identify who is the schema with DBA privilege
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Thu, 12 Jan 2012 18:39:24 -0200
Message-ID: <CAJdDhaPVsHwRC6BC5z3iOs=HWOiGgqwzmG-y0HKDT5VqN2HviQ_at_mail.gmail.com>
Hi,
I would like to know how to identify who has DBA privilege.
Date: Thu, 12 Jan 2012 18:39:24 -0200
Message-ID: <CAJdDhaPVsHwRC6BC5z3iOs=HWOiGgqwzmG-y0HKDT5VqN2HviQ_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 12 2012 - 14:39:24 CST