Hi all Ok the trigger has been changed to this, It compiles. The problem now is that all the objects
that need to be access is owner by the siebel user. I do not want to create
synonyms. The tool being used can not append the siebel schema name in front of
the objects, and it is expecting to log in as siebel. Any idea why the 'Alter session set
CURRENT_SCHEMA = SIEBEL;' is not changing my current schema. I have tried
executing Alter session set CURRENT_SCHEMA = SIEBEL; in a standard sqlplus window and then looking at the user_tables
table and it is empty ? create or replace trigger
olap1_logon_trigger after logon on smload.schema begin execute immediate
'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;'; execute immediate
'Alter session enable parallel query;'; execute immediate
'Alter session set SORT_AREA_SIZE = 10485760;'; execute
immediate 'Alter session set OPTIMIZER_MODE = choose;'; execute
immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;'; end; / George ________________________________________________ Oracle Database
Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575
0573 Fax: (+27 11) 576
0573 E-mail:[EMAIL PROTECTED] You Have The Obligation
to Inform One Honestly of the risk, And As a Person You Are Committed to
Educate Yourself to the Total Risk In Any Activity! Once Informed &
Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure
Themselves as They See Fit! -----Original Message----- George here is how we did
ours" create or replace trigger
olap1_logon_trigger Customize it to your
liking. Joe
|
- LOGON TRIGGER Buecherl Dieter (BUE)
- RE: LOGON TRIGGER Aponte, Tony
- logon trigger George Leonard (ZA)
- RE: logon trigger Paul . Parker
- Re: logon trigger Igor Neyman
- re: logon trigger JOE TESTA
- Re: logon trigger paquette stephane
- Re:logon trigger dgoulet
- RE: logon trigger George Leonard (ZA)
- RE: logon trigger Vergara, Michael (TEM)
- Re: logon trigger Igor Neyman
- RE: logon trigger George Leonard (ZA)
- RE: logon trigger George Leonard (ZA)
- RE: logon trigger George Leonard (ZA)
- RE: logon trigger Ron Thomas
- RE: logon trigger Aponte, Tony
- RE: logon trigger George Leonard (ZA)
- Logon Trigger mkb
- RE: Logon Trigger Ramon E. Estevez