changing an oracle user's default schema

posted Mar 8, 2011, 8:04 AM by Sachchida Ojha   [ updated Mar 8, 2011, 8:06 AM ]
SQL> CREATE OR REPLACE TRIGGER db_logon_user1
  2  AFTER logon ON DATABASE WHEN (USER = 'user1')
  3  begin
  4  execute immediate 'ALTER SESSION SET CURRENT_SCHEMA = schema_name';
  5  END;
  6  /

Trigger created.

Comments