Re: insufficient privileges

Is the 1031 on the create or selecting?

If on the create, the user owning the view needs to have direct privileges (i.e. not through a role) to any tables that that user does not own.
Also, if you will be then granting that view to another user to select, make sure to include the 'with grant option' when granting to the view owner.

genegurevich_at_discover.com wrote:
> Hi everybody:
>
> I have a script that creates a view. The script is failing with ORA-01031:
> insufficient privileges. When I
> execute the underlying select it works with no issue. I am unclear on how
> could this be and what could
> be the reason for this. Does anyone have an explanation?
>
> thank you
>
> Gene Gurevich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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