Oracle permission for snapshot
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!