Andy wrote:
>> 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
You are executing an UPDATE statement.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Mar 14 2006 - 13:56:20 CST
