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

"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:13:08 CDT