Hi!

I'm trying to create a snapshot using a dynamic command and the sentence:
EXECUTE IMMEDIATE command;

I need to do it this way cause i have a procedure that creates the snapshots, so it's necessary to use dynamic commands.

I've a problem cause oracle says I haven't enough privileges to do so, but if I create the command in the Toad editor directly, it works perfectly and permissions aren't a problem to create my snapshot.

The table I need to create the snapshot is already in the same schema, so it isn't a problem.

The user has these privileges:
- ALTER/CREATE/DROP/ ANY SNAPSHOT
- ON COMMIT REFRESH
- SELECT ANY TABLE
- UNLIMITED TABLESPACE

Thank you all!