Who Can Create a Database Trigger?
Database triggers can be created by:
-
Users with the
ALTER DATABASE
privilege
Database triggers can be created by:
Users with the ALTER DATABASE
privilege
CONNECT
and DISCONNECT
triggers are executed in a transaction created specifically for this purpose.This transaction uses the default isolation level, i.e. snapshot (concurrency), write and wait.If all goes well, the transaction is committed.Uncaught exceptions cause the transaction to roll back, and
for a CONNECT
trigger, the connection is then broken and the exception is returned to the client
for a DISCONNECT
trigger, exceptions are not reported.The connection is broken as intended
TRANSACTION
triggers are executed within the transaction whose start, commit or rollback evokes them.The action taken after an uncaught exception depends on the event:
In a TRANSACTION START
trigger, the exception is reported to the client and the transaction is rolled back
In a TRANSACTION COMMIT
trigger, the exception is reported, the trigger’s actions so far are undone and the commit is cancelled
In a TRANSACTION ROLLBACK
trigger, the exception is not reported and the transaction is rolled back as intended.