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:
-----
role (app_admin)
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
thing again.
Now, if I grant the user direct access to the view then it works fine.
grant select on dba_role_privs to user
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Solaris: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> create role xxxx;
Role created.
SQL> GRANT CREATE VIEW TO xxxx;
Grant succeeded.
SQL> GRANT CREATE TABLE TO XXXX;
Grant succeeded.
SQL> GRANT CREATE SESSION TO XXXX;
Grant succeeded.
SQL> GRANT ALTER SESSION TO XXXX;
Grant succeeded.
SQL> grant select on dba_role_privs to XXXX;
SQL> create user yyy identified by yyy default tablespace users
temporary tablespace temp;
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:
-----
role (app_admin)
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
thing again.
Now, if I grant the user direct access to the view then it works fine.
grant select on dba_role_privs to user
any idea???
Thanks in advance
because priveleges given to a role do not work in plsql
Bookmarks