Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: i want to consult the role assigned to one user
In article <9Forc.84305$325.1868012_at_news20.bellglobal.com>, G Dahler
says...
>
> "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=3Ft 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
>
>
>
How about :
select *
from user_role_privs;
?
-- jeremyReceived on Fri May 21 2004 - 10:04:14 CDT