How to find current roles available on a database
You can find this information in the DBA_* views in Oracle.

To find all roles in the database:

select * from dba_roles


To find what roles a particular user has:

select * from dba_role_privs where grantee=&lt;user name&gt;