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!

grant select on a synonym on remote view to a role

oraLaroJul 14 2020 — edited Jul 14 2020

Oracle 12.2

DB1 create view vw

DB2 create synonym myuser.vw as select * from vw@db1

How can I make that synonym available to all users in a particular role on DB2?  

I cant explicitly grant select on a synonym it has to be on the object but you cant do that remotely.  Am sure its an easy one but just cant think

This post has been answered by Joerg.Sobottka on Jul 14 2020
Jump to Answer
Comments
Post Details
Added on Jul 14 2020
3 comments
505 views