dba_sys_privs compared to role_sys_privs
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?
0