Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Accessing public synonym

Accessing public synonym

From: Rajesh Bhave <rajeshb_at_india.hp.com>
Date: Wed, 11 Nov 1998 19:14:45 +0530
Message-ID: <364994CD.A87C974B@india.hp.com> 





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 - 07:44:45 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US