views:

65

answers:

1

I have a homegrown Oracle role that was created long ago:

create role MyRole;

It's been granted the ability to select, insert, update, and delete from some tables and views.

grant select on sometable to MyRole;
grant insert on sometable to MyRole;
grant select on someothertable to MyRole;
-- etc.

How can I now enumerate the specific list of privileges that were granted to the role? I am interested in discovering the specific tables and the rights this role has with respect to each table. How can I recover this information?

+2  A: 

A google search for "show privileges role oracle" leads to:

Viewing Privilege and Role Information

Wade Williams
Ugh. I had looked at that exact page and it seemed that the ROLE_TAB_PRIVS view was the right thing to look at, but I was searching for the role with the wrong capitalization and it wasn't finding anything. Thanks for pointing me back in the right direction!
Chris Farmer