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 -> PL/SQL using table from another schema

PL/SQL using table from another schema

From: Jon <aaa_at_bbb.ccc>
Date: Mon, 8 Mar 2004 18:12:36 +0100
Message-ID: <c2i9i6$of4$1@unbe.sarenet.es> 





I am trying to run a procedure, created in schema_1 and that tries to select
from tables in schema_2.


I have created a public synonym to this table and schema_1 has privileges to
objects in the other schema


Should I have to grant any kind of system privileges so that schema_1 could
see these tables?


Thanks,
Received on Mon Mar 08 2004 - 11:12:36 CST












Original text of this message













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