Here you go: select grantee, GRANTED_ROLE from dba_role_privs where granted_role='DBA' order by 1 ; Ram Srinivasan ================ On Thu, Jan 12, 2012 at 3:44 PM, Stephane Faroult <sfaroult@xxxxxxxxxxxx>wrote: > > 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 > > > > If I were you I would create my own view on top of sys.user$ and > sys.sysauth$. > > -- > Stephane Faroult > RoughSea Ltd <http://www.roughsea.com> > Konagora <http://www.konagora.com> > RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd> > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Sincerely Ram Srinivasan -- //www.freelists.org/webpage/oracle-l