I have two databases running in my system , pdborcl and remotedb . These are two publisher databases running in my server.
I have created a public database link from PDBORCL to connect to remotedb by username sam.
I have an table called emp in sam schema in remotedb, I have created a public synonym on this table from pdborcl db in hr schema.
Iam able to perform all the DML and select operations on the remote table from hr schema without giving any permissions . How is it possible . Can anyone explain me how this is working.