RE: Senior moment
- From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <tomday2@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Dec 2006 10:59:35 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
------------------------------------------------------------------------
-------- -----------------
ADC_CD
NOT NULL VARCHAR2(2)
ADC_DESC
NOT NULL VARCHAR2(80)
ADC_CLOSE_DT
DATE
SQL> select count(*) from ADDRESS_CDS;
COUNT(*)
----------
0
Other related posts:
