Example: Creating a Simple Logon Trigger

The CREATE TRIGGER statement can create a simple logon trigger. The following example shows a simple logon trigger that runs a PL/SQL procedure.

CREATE OR REPLACE TRIGGER set_empno_ctx_trig AFTER LOGON ON DATABASE
 BEGIN
  sec_mgr.set_empno_ctx_proc;
 END;