Errors and Database event triggers

6.11.3 Errors and Database event triggers

When using Database event triggers, you need to grant the Manage database triggers permission directly to the account that owns the trigger. Otherwise, you may encounter errors.

This is the background of the error message: A user is creating a table and attempting to use the word list (an invalid identifier) as the column name. The system-wide server Error Event trigger is ready, but the trigger is not available. The Oracle server attempted to recompile the trigger, but the compilation failed because the trigger owner has permission to administer the database triggers through the role authorization.

A database event trigger can have a significant impact if an error occurs. If a login trigger is wrong, it is likely to prevent a user who has no permissions from logging in. If the server Error event trigger saves all errors in the error table and the table fills up (or touches another error condition), any session that causes the error is frozen.