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, thank you.
On Fri, 21 May 2004 10:44:05 -0400, "G Dahler" <yellow-shark_at_spamex.com> wrote:
>
>"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'
>/
>
Received on Fri May 21 2004 - 09:57:05 CDT