Try with "ADMINISTER DATABASE TRIGGER" On 2003.08.13 04:29, Jack van Zanen
wrote:
Yes I tried granting alter session first
-----Original Message-----
Sent: Tuesday, August 12, 2003 11:24 PM
To: Multiple recipients of list ORACLE-L
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).
--
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).
--
Mladen Gogala
Oracle DBA
--
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).
