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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2009

Added on Mar 20 2009

#general-database-discussions

4 comments

645 views