Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Senior moment
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
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
COUNT(*)
0
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 07 2006 - 09:59:35 CST