Re: Accessing public synonym

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 11 Nov 1998 15:23:55 +0100
Message-ID: <36499DFB.96973F1@sybrandb.demon.nl>

Hi Rajesh,
SCHONE can only access SCHTWO.DEPT by prefixing DEPT with SCHTWO. This is because Oracle resolves objectnames in the sequence table owner, private synonym, public synonym. So by referring to DEPT only, SCHONE will NEVER see SCHTWO.DEPT. Of course SCHONE needs at least select privilege on SCHTWO.DEPT to be able to see it.

Hth,

Sybrand Bakker, Oracle DBA

Rajesh Bhave wrote:

> Hello
>
> Can you clarify following doubt :
> If SCHONE and SCHTWO contain table DEPT, SCHONE does not have access
> privilege on SCHTWO.DEPT. User SYSTEM creates PUBLIC synonym named DEPT
> for SCHTWO.DEPT. How can SCHONE access SCHTWO.DEPT table ? I need to
> clarify this because public synonym created by user SYSTEM is also named
> DEPT.
>
> Thanks and Regards,
> Rajesh Bhave
Received on Wed Nov 11 1998 - 08:23:55 CST