Database Security Products (MOSC)

MOSC Banner

dba_sys_privs compared to role_sys_privs

edited Apr 23, 2014 12:00PM in Database Security Products (MOSC) 5 commentsAnswered
I am on oracle version 11.2.0.1 and run a query as the sys user against role_sys_privs view like below to generate grant statements to particular roles.  when I run this in one db I get plenty of results but when I run it on another db I get no results and I am farily certain these roles exists in both databases.  I do not have access to the db its returning 0 results in.   I have to pass the sql along to dba there but he runs and gets no results. 

I am guessing that if I have him use dba_sys_privs and use grantee = to the same roles I will get results.  So why does role_tab_privs and role_sys_privs not always match dba_tab_privs and dba_sys_privs?

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