Re: Senior moment

Bingo - Google is your friend

"If you are creating a materialized view log for a table in another user's schema, you must have the CREATE ANY TABLE and COMMENT ANY TABLE system privileges, as well as either the SELECT object privilege on the master table or the SELECT ANY TABLE system privilege."

I underestimated the power of google.

I searched for
CREATE MATERIALIZED VIEW LOG privileges oracle and got the above.

Thanks all.

On 12/7/06, Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com> wrote:
>
> Senior moments… I did not read the rest of the email…. To see you were
> trying to create a materialized view.
>
>
>
> Joel Patterson
> Database Administrator
> joel.patterson_at_crowley.com
> x72546
> 904 727-2546
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Mercadante, Thomas F (LABOR)
> *Sent:* Thursday, December 07, 2006 11:00 AM
> *To:* tomday2_at_gmail.com; Oracle-L Freelists
> *Subject:* 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
>
>
> ------------------------------
>
> 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
> ------------------------------------------------------------------------
> -------- -----------------
> ADC_CD
> NOT NULL VARCHAR2(2)
> ADC_DESC
> NOT NULL VARCHAR2(80)
> ADC_CLOSE_DT
> DATE
>
> SQL> select count(*) from ADDRESS_CDS;
>
> COUNT(*)
> ----------
> 0
>
>
>

--
http://www.freelists.org/webpage/oracle-l