“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.

← Installation variables / Implementation →


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment