Re: Permissions required for create materialized view dynamically

Comments embedded

On Tue, 21 Dec 2004 19:23:01 GMT, "Jack Addington" <jaddington_at_shaw.ca> wrote:

>I am trying to write a stored procedure that dynamically drops/creates a
>snapshot.

Which obviously is a bad idea. Objects shouldn't be created on the fly. What business need do you have you think you 'need' this 'feature'

 I got all the sql right (I think) but I am running into a
>insufficient privileges message when it fires. If I take the same code an
>run it directly it creates the MV just fine. I am running as the schema
>owner right now. I even tried altering the code to do a create view and I
>got the same error message.
>
>What permissions could I be missing?

This question must have been answered a million times, the answer has been provided at least as often, and yet people still fail to read documentation and/or search Google, prior to asking this boring question *again* for the umpteenth time. Why would there be Google anyway?
The answer is your privileges are through a role. For the rest of the answer either search Google on 'insufficient privileges' or read up on 'definer's rights' and 'invokers rights' in the documentation.

--
Sybrand Bakker, Senior Oracle DBA