<< Click to Display Table of Contents >>

Schema Triggers

Top Previous Next

This sheet lists schema triggers for the current schema—those listed in the Data Dictionary's ALL TRIGGERS view with BASE_OBJECT_TYPE equal to 'SCHEMA'. These triggers fire on either a DDL event or a database event occurring within a particular schema.

This is essentially the same information presented on the Schema Triggers sheet of the Users page. It is made available here for users who do not have access to Hora's DBA functions to see their own schema triggers or those for which they have been granted privileges by another user.

The following context menu operations are available from the grid:

TablesTriggersCreate

Create

Shows the Create Trigger dialog

07_Drop

Drop ...

Drops the highlighted trigger

 

Compile

Compiles the highlighted trigger

 

Compile Debug

Compiles the highlighted trigger with the Debug option

Enable

Enable

Enables the highlighted trigger

DISABLE

Disable

Disables the highlighted trigger