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

thank you, i will prove this.

On Fri, 21 May 2004 16:13:08 +0200, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

>
>"juan" <aaaaa_at_aaa.com> a écrit dans le message de news:0l1sa0trkf7d12fe2t3b2dftgvscct47h6_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.
>
>dba_role_privs
>
>For instance,
>select granted_role from dba_role_privs where grantee='<your user>';
>
>Regards
>Michel Cadot
>
Received on Fri May 21 2004 - 09:25:45 CDT