Re: How to identify who is the schema with DBA privilege
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Thu, 12 Jan 2012 21:15:16 -0300
Message-ID: <CAJ2dSGS5UXus0es_f+jUXfQBLFsNKOU9AVGVJi2rTUuBgtsWVQ_at_mail.gmail.com>
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.
Alan.-
Date: Thu, 12 Jan 2012 21:15:16 -0300
Message-ID: <CAJ2dSGS5UXus0es_f+jUXfQBLFsNKOU9AVGVJi2rTUuBgtsWVQ_at_mail.gmail.com>
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.
Alan.-
On Thu, Jan 12, 2012 at 6:18 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:
> You'll want a recursive version, but Pete Finnigan already has one,
> http://www.petefinnigan.com/weblog/archives/00001243.htm
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 12 2012 - 18:15:16 CST