Oracle Maestro online help
Prev | Return to chapter overview | Next |
Specifying schema trigger properties
![](/i/tour-under-title.gif)
The wizard step was supplied to define common schema trigger properties. The detailed description of the properties you can find below.
Name
The field represents the new schema trigger name as it was set on the previous wizard step.
Owner
The field displays the owner of the new trigger.
Enabled
Check the option to enable the trigger.
When fire (Before, After)
Specify Before to cause the database to fire the trigger before executing the triggering event. For row triggers, the trigger is fired before each affected row is changed. Specify After to cause the database to fire the trigger after executing the triggering event. For row triggers, the trigger is fired after each affected row is changed.
When condition
Specify the trigger condition, which is a SQL condition that must be satisfied for the database to fire the trigger.
Specify the Schema name to define the trigger on the current schema. The trigger fires whenever any user connected as schema initiates the triggering event.
alter
Specify alter to fire the trigger whenever an ALTER statement modifies a database object in the data dictionary.
analyze
Specify analyze to fire the trigger whenever the database collects or deletes statistics or validates the structure of a database object.
associate statistic
Specify ASSOCIATE STATISTICS to fire the trigger whenever the database associates a statistics type with a database object.
audit
Specify audit to fire the trigger whenever the database tracks the occurrence of a SQL statement or tracks operations on a schema object.
comment
Specify comment to fire the trigger whenever a comment on a database object is added to the data dictionary.
create
Specify create to fire the trigger whenever a CREATE statement adds a new database object to the data dictionary.
diassociate statistic
Specify diassociate statistic to fire the trigger whenever the database disassociates a statistics type from a database object.
drop
Specify drop to fire the trigger whenever a DROP statement removes a database object from the data dictionary.
grant
Specify grant to fire the trigger whenever a user grants system privileges or roles or object privileges to another user or to a role.
no audit
Specify no audit to fire the trigger whenever a no audit statement instructs the database to stop tracking a SQL statement or operations on a schema object.
rename
Specify rename to fire the trigger whenever a rename statement changes the name of a database object.
revoke
Specify revoke to fire the trigger whenever a revoke statement removes system privileges or roles or object privileges from a user or role.
truncate
Specify truncate to fire the trigger whenever a truncate statement removes the rows from a table or cluster and resets its storage characteristics.
DDL
Specify DDL to fire the trigger whenever any of the preceding DDL statements is issued.
Prev | Return to chapter overview | Next |