To delete a trigger, you must have the Oracle Rdb DELETE privilege
    to the relation for which the trigger is defined.

    You must execute this statement in a read/write transaction.
    If there is no active transaction and you issue this statement,
    Oracle Rdb starts a read/write transaction implicitly.

    Other users are allowed to be attached to the database when you
    issue the DELETE TRIGGER statement.