Re: i want to consult the role assigned to one user

From: G Dahler <yellow-shark_at_spamex.com>
Date: Fri, 21 May 2004 10:48:28 -0400
Message-ID: <9Forc.84305$325.1868012@news20.bellglobal.com>

"G Dahler" <yellow-shark_at_spamex.com> a écrit dans le message de news:2Borc.84244$325.1866734_at_news20.bellglobal.com...
>
> "juan" <aaaaa_at_aaa.com> a écrit dans le message de
> news:be0sa0tpp32evanncp1jt55b1cqeadht75_at_4ax.com...
> > i am spanish and my english is very bad, please the answres not
> > difficult, thank you.
> >
> > i want to consult the role assigned to one user, in what table or view
> > have i to consult.
> > i make the role, isn´t a system role.
> > thank you.
>
> Select *
> from dba_role_privs
> where grantee='YOUR_USER_HERE'
> /
>

I forgot to say that DBA_ROLE_PRIVS is not accessible to any user. Connect as SYS or DBA Received on Fri May 21 2004 - 09:48:28 CDT