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!

Grant select to synonym

kazyskiyn0wFeb 26 2014 — edited Feb 26 2014

Hi All,

I created a new user and need to grant just select to it.

If I grant select owner.table to user , USR1 can perform the query: select count(*) from owner1.table1 ;

But if I query select count(*) from table1 the message is ORA-00942 table or view does not exist.

question is: How can I grant select to the synonym without having to use schema.table ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2014

Added on Feb 26 2014

#general-database-discussions

6 comments

11,511 views