can't access dba_role_privs view anymore after upgrading from 10g to11gR2
the Applicatin Admin of our system can no longer access this view
dba_role_privs since we upgraded from 10g to 11gR2.
this is what I have before:
grant select on dba_role_privs to app_admin
grant app_admin to user -- applicatioin administrator
the above doesn't work anymore even after I recreated the whole
Now, if I grant the user direct access to the view then it works fine.
grant select on dba_role_privs to user
Thanks in advance
Click Here to Expand Forum to Full Width