How to find current roles available on a database

Question

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 :)

your supposed to know what roles you run a function, by definition. — Mitch Wheat, Dec 17 '13 at 10:38
and how I am supposed to know that... Actually I want to provide grant to another user of the same database... but not sure what roles I should grant access on. — akhil, Dec 17 '13 at 10:39
Be aware that role grants do not work as you think they do when packages and stored procedures are concerned. See Tom explaining asktom.oracle.com/pls/asktom/… — Philᵀᴹ, Dec 17 '13 at 15:52

GTG · Accepted Answer · 2013-12-17 11:46:36Z

4

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=<user name>

answered Dec 17 '13 at 11:46

GTG

1562 bronze badges

add a comment |

1 Answer 1