ITPub博客

With the introduction of the 20 new database triggers, came the creation of attribute events or variables that are set when a certain database trigger event is executed. The previous section highlighted each of the database triggers, along with the event attributes that are set and can be referenced for each trigger. Below is a list of each of the attribute events, the data type and a short description.Attribute EventData TypeDescriptionora_client_ip_addressVARCHAR2Provides the IP address of the

There are six database system event triggers. The six database system event triggers are outlined below, along with a description and the event attributes that are set for each event.Database TriggerBEFORE/AFTER ExecutionDescriptionAttribute EventLOGOFFBEFOREExecuted when a user logs off, at the start of the logoff processora_syseventora_login_userora_instance_numora_database_nameLOGONAFTERExecuted when a user logs into the database, after a successful login of the userora_syseventora_login_user

DDL/Client EventsThere are 14 DDL/client event triggers and these can be created at the database level and will execute for all schemas, or these can be created at the schema level and will execute only for the schema it is created for. When a trigger is created at the schema level, the trigger is created in the schema specified and executes only for that schema.This provides a great deal of flexibility depending on your environment and what you want to monitor or respond to. The 14 DDL/client e

IntroductionCreation of Database TriggersA database trigger is created and dropped with the following commands:    CREATE OR REPLACE TRIGGER trigger_name (BEFORE|AFTER)                  database_trigger_event ON (DATABASE|schema.SCHEMA)…;    DROP TRIGGER trigger_name;When a database trigger is created, the trigger is checked for syntax, the dependency tree and privileges are checked,&nb