Not insufficient privileges to crate a view on dba_tables
626620Sep 9 2008 — edited Sep 17 2008On our new 10.2.0.3.0 RAC instance, I have DBA role and CREATE ANY VIEW system privilege, but when doing the following:
create or replace view vw_dba_tables as select owner,table_name from dba_tables order by 1,2
got error
SQL Error: ORA-01031: insufficient privileges
I can work around by
create table tbl_dba_tables as select owner,table_name from dba_tables order by 1,2;
and then
create or replace view vw_dba_tables as select * from tbl_dba_tables;
But this is not what I really want.
While on the old 10.1.0.5.0, I do NOT have this ORA-01031: insufficient privileges error and view can be created on any dictionary objects.