Re: Update statement using a join on a materialized view

>
> Is this happening in SQL or in PL/SQL?
> Does your Oracle installation have a version number?
>
> Likely you are in a PL/SQL procedure and the privilege on the
> materialized view has been granted through a role: It must be explicit.
> --

Hi

This is in SQL not PL/SQL and this is on Oracle 9i

The materialized view is owned by another user and I believe my user only has select access, my question is that because i'm not updating the materialised view why would I need update access to it ?

Cheers

Andy Received on Tue Mar 14 2006 - 11:35:11 CST