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!

create public synonym

- A -Mar 20 2009 — edited Mar 25 2009
Hi,

I am using oracle database 10gR1 on windows. I have a schema with the name of SMS and grant create synonym system privilige to sms user.I want to create only public synonym for sms tables But it return error ORA-01031: insufficient privileges. Is there some there missing?




Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2009
Added on Mar 20 2009
4 comments
645 views