Re: find out the role of a user

Joerg Leute wrote:
>
> Hi everybody
>
> is there any way i can find out which roles are assigned to a user? (i mean
> by an sql-statement, not in the GUI)
>
> Thanks in advance
>
> Joerg

select * from dba_role_privs
where grantee = user;

Juhan Received on Thu Apr 08 1999 - 08:23:51 CDT