Role of particular user?

[elziko]

How would I find the role of a particular user. Or in what table would this information be stored so that I can use SQL to find out a users priveleges??

Many Thanks

elziko

 

[13579]

u can find the role of particular user using following two table
sys.dba_users , sys.dba_sys_privs

 

[karluk]

The roles that have been granted to an id can be found in dba_role_privs. E.g. SELECT GRANTEE,GRANTED_ROLE FROM DBA_ROLE_PRIVS;