“Pre implementation” is used to issue grants or create objects as another user, before the implementation step. Its optional, and in this example used to issue grants that is needed by the implementation procedure.
“Execute as user” is the user used to execute the command. The variable “;;inst-user;;” is substituted to the privileged user used when this instance was added to dbWatch Control Center.
This example grant also uses “[Inst: dbWatch schema]” which is substituted on execution with the schema/login name of the dbWatch Control Center user, by default dbwatch_cc.
You can also add a cleanup code. This can be for dropping objects etc. It can be executed before or after the main statement.
The substitutions are available when you right-click in the editor.
Post your comment on this topic.