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
ok.
On Fri, 21 May 2004 10:48:28 -0400, "G Dahler" <yellow-shark_at_spamex.com> wrote:
>
>"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:58:19 CDT