Database Security Products (MOSC)

MOSC Banner

How to get all privileges assigned to a particular role

edited Apr 25, 2013 11:06PM in Database Security Products (MOSC) 18 commentsAnswered
I need to get a list of privileges assigned to a particular role.

I tried

SELECT ROLE, PRIVILEGE FROM ROLE_SYS_PRIVS WHERE ROLE='ROLE1';

SELECT ROLE, GRANTED_ROLE FROM ROLE_ROLE_PRIVS WHERE ROLE='ROLE1';

SELECT ROLE, TABLE_NAME, PRIVILEGE FROM ROLE_TAB_PRIVS;

but neither returned any rows. Am I missing anything or the role really does not have any privileges assigned to it?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center