Re: How to identify who is the schema with DBA privilege

  • From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
  • To: niall.litchfield@xxxxxxxxx
  • Date: Thu, 12 Jan 2012 21:15:16 -0300

If you can't see DBA_ROLE_PRIVS (getting ora-942) you probably don't have
select privileges on it, because the view does exist. If querying dba_views
doesn't show it, then you probably need to run the catalog scripts... but
I'd open a SR with MOS in that case.

On Thu, Jan 12, 2012 at 6:18 PM, Niall Litchfield <
niall.litchfield@xxxxxxxxx> wrote:

> You'll want a recursive version, but Pete Finnigan already has one,
> --


Other related posts: