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