Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> creating ALTER SESSION SET CURRENT_SCHEMA trigger on logon to Db on 8i or 9i

creating ALTER SESSION SET CURRENT_SCHEMA trigger on logon to Db on 8i or 9i

From: Doron <doron_almog_at_msn.com>
Date: 10 Jun 2003 13:31:31 -0700
Message-ID: <995517bc.0306101231.41fd2534@posting.google.com> 





hi,


trying to create a trigger on logon to the db to change a users
current_schema but getting invalid trigger specification error.



CREATE TRIGGER "JOE"."DEF_SCHEMA" AFTER



LOGON ON DATABASE 'ALTER SESSION SET CURRENT_SCHEMA = SCOTT';


was anybody able to get this to work
Received on Tue Jun 10 2003 - 15:31:31 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US