After logon database trigger : Database Trigger « Trigger « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Trigger
  3. Database Trigger

After logon database trigger

   


SQL>
SQL>
SQL> CREATE OR REPLACE TRIGGER change_schema AFTER logon ON DATABASE
  2  begin
  3   execute immediate('alter session set current_schema=app_master');
  4  end;
  5  /

Trigger created.

SQL>
SQL> drop trigger change_schema;

Trigger dropped.








Related examples in the same category

1.Trigger for database startup event
2.Trigger to log the database shutdown
3.Logon trigger
4.Log database logon to a table
5.Log a server error to a table
6.Log a server error with information on time, user name, database name
7.A system trigger(AFTER CREATE ON DATABASE) .
8.creating a logon/logoff auditing system using system-level triggers:
9.Save information about all errors in an after-servererror on database
10.Submit a job for altering user in an after-create-database trigger