Example in profiles and roles(particular user)

[FSM]

How can i get info about a "particular" user regarding is profiles and roles, I've already checked out the "dba_roles and dba_sys_privs" but i want to know about a particular user can some one write and example??

Thanx guys!!!!

 

[rcurva]

For the Profiles, you can play around these views:

DBA_USERS, DBA_PROFILES

For the Roles;

DBA_USERS, DBA_ROLE_PRIVS, ROLE_ROLE_PRIVS

For System/Object privileges;

DBA_USERS, DBA_SYS_PRIVS, DBA_TAB_PRIVS
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War