Permissions required for create materialized view dynamically

I am trying to write a stored procedure that dynamically drops/creates a snapshot. 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? The snapshot is fairly straight forward and selects only from local tables and uses a few procedure calls.

thx

jack Received on Tue Dec 21 2004 - 13:23:01 CST