Does the user whom you created the trigger have "alter session" privilege?
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, August 12, 2003 4:39 PM > As system (8.1.7.3): > > create or replace trigger <TRIGGER_NAME> > after logon on <SCHEMA>.schema > begin > Execute immediate 'alter session set events=''10046 trace name context > forever, level 12'''; > end; > > > When I logon after creating this trigger as the user <SCHEMA> I get the > error message insufficient privileges. > If I grant DBA it seems to work but that is a bit much for privileges. > > Which privileges are neccesary to run this?? > > Just alter session won't work. > > > Jack > > > -----Original Message----- > Sent: Monday, August 11, 2003 4:59 PM > To: Multiple recipients of list ORACLE-L > > > Create or replace database trigger turn_tracing_on after logon on > schema.scott Begin Execute immediate 'alter session set events=''10046 trace > name context forever, level 8'''; End; / > > That should give you more then enough info to trace, especially on 9i. > > -- > Mladen Gogala > Oracle DBA > > > > -----Original Message----- > Senthil Kumar > Sent: Monday, August 11, 2003 10:39 AM > To: Multiple recipients of list ORACLE-L > > > Hi All, > > I'm loading a set of data into one of my schema. And wanted to take the > trace files also. > > I tried the follwoing. > > 1. Identified the sid,serila# for the sql*loader session. > 2. used the follwoing, > exec sys.dbms_system.set_sql_trace_in_session(19,11250,TRUE); > > but this is not generation any trace files. But if I trun my system to > sql_trace=TRUE, I'm able to collect the trace details. I don't want to do > this. > > I want to take the trace only for the sql*loader session. How do i do that. > > TIA, > Senthil. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Senthil Kumar > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > message BODY, include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also send the HELP > command for other information (like subscribing). > > > -------------------------------------------------------- > Note: > This message is for the named person's use only. It may > contain confidential, proprietary or legally privileged > information. No confidentiality or privilege is waived > or lost by any mistransmission. If you receive this > message in error, please immediately delete it and all > copies of it from your system, destroy any hard copies > of it and notify the sender. You must not, directly or > indirectly, use, disclose, distribute, print, or copy > any part of this message if you are not the intended > recipient. Wang Trading LLC and any of its subsidiaries > each reserve the right to monitor all e-mail > communications through its networks. > > Any views expressed in this message are those of the > individual sender, except where the message states > otherwise and the sender is authorized to state them > to be the views of any such entity. > --------------------------------------------------------- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > message BODY, include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also send the HELP > command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jack van Zanen > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
