How to find current roles available on a database I am looking to provide grant to one of my function in my database.
However, I am not sure what roles I should give access to.

I searched for it but can't find list of roles for all the users.

Any idea guys as which table I should be looking into.

I am using Oracle 11g.

Thanks in Advance :)
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;