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. |
changing an oracle user's default schemaposted Mar 8, 2011, 8:04 AM by Sachchida Ojha [ updated Mar 8, 2011, 8:06 AM ]
|