Skip to Main Content

SQL & PL/SQL

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!

what can i do for creating view on a public synonym?

684380Apr 27 2009 — edited Apr 27 2009
Hi people,
I have create a public synonym for other users object as,

SQL> create public synonym pdep for scott.dept;


Synonym created.

then i tend to create a view on this public syn as,

SQL> create view vpdep as select * from pdep;
create view vpdep as select * from pdep
*
ERROR at line 1:
ORA-01031: insufficient privileges

I have privilege to create view.also i can create view on a public synonym of my own objects.for ex,

SQL> create public synonym cdep for dept;

Synonym created.

SQL> create view vcdep as select * from cdep;

View created.

what could be the reason behind this?is there any privilege required for me.pls suggest me.

Regards
VIDS
This post has been answered by Florian W. on Apr 27 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2009
Added on Apr 27 2009
4 comments
394 views