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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Senior moment

RE: Senior moment

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 7 Dec 2006 10:59:35 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE0892E@EXCNYSM0A1AJ.nysemail.nyenet>


Thomas,  

You need to grant access to the table directly to the second user rather than through the ROLE. You are creating a PL/SQL package against the table. You must have direct access to it - not inherited thru the role.

Tom  



This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Day Sent: Thursday, December 07, 2006 10:33 AM To: Oracle-L Freelists
Subject: Senior moment  

Oracle 9.2 on AIX  

I've created a table (table a) under one schema with a public synonym and granted select to a role.  

In another schema, with that role, I've created another schema. I can select count(*) from table a in this second schema but when I try to create a foreign key or a materialized view log I get -  

ORA-00942: table or view does not exist  

I'm sure that I'm missing something obvious, I just can't think what it is. All suggestions welcome.



SQL> CREATE MATERIALIZED VIEW LOG ON ADDRESS_CDS tablespace dss_DATA   2 WITH SEQUENCE(
  3 ADC_DESC
  4 ,ADC_CLOSE_DT
  5 ) INCLUDING NEW VALUES
  6 /
CREATE MATERIALIZED VIEW LOG ON ADDRESS_CDS tablespace dss_DATA *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> desc ADDRESS_CDS
 Name
Null? Type  


SQL> select count(*) from ADDRESS_CDS;

  COUNT(*)


         0

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 07 2006 - 09:59:35 CST

Original text of this message

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