Hiding an event handler

For improved security, you can hide the definition for an event handler using the ALTER EVENT statement.

Prérequis

You must have either the MANAGE ANY EVENT or ALTER ANY OBJECT system privilege.

Connect to the database.
Execute an ALTER EVENT statement with the SET HIDDEN clause:
ALTER EVENT event-name SET HIDDEN

Résultat

The event handler is permanently obfuscated in the event handler definition that is stored in the action column of the ISYSEVENT system table.

Exemple

The following statement hides the definition of the event handler secret_event:

ALTER EVENT secret_event SET HIDDEN