RE: logon trigger to start tracing

Oracle9i 9.2.0.3.0, O7_DICTIONARY_ACCESSIBILITY is FALSE. --- Jacques Kilchoer [EMAIL PROTECTED] wrote: What database version? What is your setting for O7_DICTIONARY_ACCESSIBILITY? I tried the following in an 8.1.7 database with O7_DICTIONARY_ACCESSIBILITY = FALSE create user x identified

Re: logon trigger to start tracing

That's it! Thanks...sometimes I forget that a trigger is a stored object, too. Regards, --- Wolfgang Breitling [EMAIL PROTECTED] wrote: The logon user needs to have granted alter session privileges directly to her, not just through a role. = Paul Baumgartel Transcentive, Inc.

RE: logon trigger to start tracing

Title: RE: logon trigger to start tracing Paul, remember it is a trigger ... so it runs under executing user's privs ... 1. everyone needs a direct grant for execute on dbms_session 2. there needs to be a public synonym for dbms_session 3. yell Bingo! Raj

RE: logon trigger to start tracing

--- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Paul, remember it is a trigger ... so it runs under executing user's privs ... 1. everyone needs a direct grant for execute on dbms_session Been there. 2. there needs to be a public synonym for dbms_session Done that. 3. yell Bingo!

RE: logon trigger to start tracing

-Original Message- From: Wolfgang Breitling [mailto:[EMAIL PROTECTED] The logon user needs to have granted alter session privileges directly to her, not just through a role. I believe you that it's needed for DBMS_SESSION.SET_SQL_TRACE, but then why was I able to get a trace

RE: logon trigger to start tracing

Never mind. I see that DBMS_SESSION has AUTHID CURRENT_USER (and of course DBMS_SUPPORT does not.) -Original Message- From: Jacques Kilchoer -Original Message- From: Wolfgang Breitling [mailto:[EMAIL PROTECTED] The logon user needs to have granted alter session

RE: logon trigger to start tracing

What database version? What is your setting for O7_DICTIONARY_ACCESSIBILITY? I tried the following in an 8.1.7 database with O7_DICTIONARY_ACCESSIBILITY = FALSE create user x identified by ... ; grant create session, create trigger to x ; (logging on as SYSDBA) grant execute on sys.dbms_support

Re: logon trigger to start tracing

The logon user needs to have granted alter session privileges directly to her, not just through a role. At 03:54 PM 7/22/2003 -0800, you wrote: In an attempt to catch all SQL issued by a report, I created a logon trigger in the report's logon schema. (As SYS, I granted the user EXECUTE on

RE: logon trigger

Hi Mike Siebel has released a note whereby they approve CBO for the EIM process. Also what I have is a SM Data warehouse logon into the OLTP Siebel db. The activities this logon does is more akin to OLAP. So what I am doing is giving this logon a big sort area size, enabling parallel access for

RE: logon trigger

Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: 02 October 2002 19:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: logon trigger Altering current_schema, you will not see anything

RE: logon trigger

, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- From: George Leonard (ZA) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 09:03 AM To: Multiple recipients of list ORACLE-L Subject: RE: logon trigger Thx, I also found this last night. I

RE: logon trigger

PROTECTED] 10/03/02 02:43 AMcc: Please respond toSubject: RE: logon trigger

RE: logon trigger

Do you happen to have that note number? Tony Aponte -Original Message- Sent: Thursday, October 03, 2002 2:58 AM To: Multiple recipients of list ORACLE-L Hi Mike Siebel has released a note whereby they approve CBO for the EIM process. Also what I have is a SM Data warehouse logon

RE: logon trigger

cc: Please respond toSubject: RE: logon trigger ORACLE-L Hi all Ok if I execute these commands/SQL in sqlplus it works. When I add to the trigger for after logon it does not work. I get the feeling it is only valid

Re: logon trigger

Alter session ... is not DML, so I think you need to use dynamic SQL: create or replace trigger smload.logon after logon on database begin SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01; EXECUTE IMMEDIATE Alter session enable parallel query; EXECUTE IMMEDIATE Alter session set SORT_AREA_SIZE =

re: logon trigger

George here is how we did ours" create or replace trigger olap1_logon_trigger after logon on olap1.schemabegin execute immediate 'alter session set optimizer_mode = first_rows';end;/ Customize it to your liking. Joe

Re: logon trigger

Hi, Use dynamic SQL (execute imediate). Also, consider placing your code into a stored proc called by the trigger. --- George Leonard (ZA) [EMAIL PROTECTED] a écrit : Hi guys I am trying to create the following trigger. The user in question is logging in using siebel application and

RE: logon trigger

to Kill or Injure Themselves as They See Fit! -Original Message- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: 02 October 2002 16:52 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: re: logon trigger George here is how we did ours create or replace trigger

Re: logon trigger

e Leonard (ZA) To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 02, 2002 12:18 PM Subject: RE: logon trigger 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

RE: logon trigger

In looking at this and thinking about it...doesn't any DDL statement do an implied COMMIT? If so, the first EXECUTE IMMEDIATE will fire, commit, the SET TRANSACTION will be released, and the user will not be assured of using that rollback segment. Shouldn't the SET TRANSACTION be the last

RE: LOGON TRIGGER

Title: RE: LOGON TRIGGER Here what we've done to alter the optimizer goal at logon time. CREATE OR REPLACE TRIGGER change_optimizer_on_startup AFTER LOGON ON DATABASE DECLARE p_osuser_txt V$SESSION_CONNECT_INFO.OSUSER%TYPE; BEGIN BEGIN SELECT OSUSER INTO p_osuser_txt FROM V$SESSION