Who Can Alter A Trigger?

VIEWPROCEDURE

Who Can Alter a Trigger?

DML triggers can be altered by:

Administrators
The owner of the table (or view)
Users with — for a table — the ALTER ANY TABLE, or — for a view — ALTER ANY VIEW privilege

Database and DDL triggers can be altered by:

Administrators
Users with the ALTER DATABASE privilege

Examples using ALTER TRIGGER

Deactivating the set_cust_no trigger (switching it to the inactive status).
```
ALTER TRIGGER set_cust_no INACTIVE;
```
Changing the firing order position of the set_cust_no trigger.
```
ALTER TRIGGER set_cust_no POSITION 14;
```
Switching the TR_CUST_LOG trigger to the inactive status and modifying the list of events.
```
ALTER TRIGGER TR_CUST_LOG
INACTIVE AFTER INSERT OR UPDATE;
```

Switching the tr_log_connect trigger to the active status, changing its position and body.

ALTER TRIGGER tr_log_connect
ACTIVE POSITION 1
AS
BEGIN
  INSERT INTO LOG_CONNECT (ID,
                           USERNAME,
                           ROLENAME,
                           ATIME)
  VALUES (NEXT VALUE FOR SEQ_LOG_CONNECT,
          CURRENT_USER,
          CURRENT_ROLE,
          CURRENT_TIMESTAMP);
END