Database Security Products (MOSC)

MOSC Banner

Question About Access to a Private Synonym Using A Public DB Link

edited Jul 8, 2010 10:04AM in Database Security Products (MOSC) 13 commentsAnswered
 Hello:

In database sbd5, I added a public database link to sbq3 and then used it to create (what I believe) is a private synonym owned by user phoenix: 

create public database link SBQ3@PHXCURT connect to PHXCURT identified by <password> using SBQ3;
create or replace synonym PHOENIX.TBOM20 for PHXCURT.TBOM20@SBQ3@PHXCURT;

I was very surprised to find that a different user, phrpt, can also use this synonym and retrieve data from the remote database.
User phrpt has no privileges on phoenix objects in sbd5.  However, user phrpt does have select (through a role) on phxcurt.tbom20 in the remote database.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center