• Product Information
  • About
  • Product tour
  • News
  • Screenshots
  • Testimonials
• Support Information
  • Documentation
  • FAQ
  • Support
  • Upgrade policy
• Download
• Purchase

Download Buy

Oracle Maestro online help

Specifying schema trigger properties

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.