|
Answer» These triggers are defined on system-level. The triggers are fired at system-level events, such as logon, logoff, startup, and DDL, which are explained as follows:
- Database startup triggers —Refer to the triggers that are fired at database startup. These can be used to automate certain action that you want to perform every time at startup.
- Logon triggers —Refer to the triggers that are fired at logon. You can use these TRIGGER to generate AUDIT information related to logon.
- Logoff triggers —Refer to the triggers that are fired at logoff time. You can include certain session closure related activities in these triggers.
- Server error triggers —Refer to the triggers that are fired at server error. These triggers can be used to log error details and send email NOTIFICATION.
- DDL triggers --Refer to the triggers that are fired at DDL operations and can be used to audit DDL CHANGES.
These triggers are defined on system-level. The triggers are fired at system-level events, such as logon, logoff, startup, and DDL, which are explained as follows:
|