Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not insufficient privileges to crate a view on dba_tables

626620Sep 9 2008 — edited Sep 17 2008
On 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2008
Added on Sep 9 2008
7 comments
1,442 views