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!

Grant synonym for specific user

583525Jul 11 2007 — edited Jul 11 2007

I am logged in as 'scott' and want to create a synonym for user 'bob' only (no other users) for scott's table emp.

create public synonym emp for scott.emp

will allow all users to access scott.

How do I restrict the synonym to one (or several) users?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 8 2007

Added on Jul 11 2007

4 comments

922 views