On Sep 1, 11:17 am, shawnrhall <shawnrh...@gmail.com> wrote:
> I'm trying to setup tracing by user_id on login. Here is the trigger,
> yet it seems to ignore the the IF statement and enables tracing for
> ALL logins any ideas?
>
> CREATE OR REPLACE TRIGGER ENABLE_TRACE_ON_DTRAQ AFTER logon ON
> DATABASE
> DECLARE
> p_session_user varchar2(64);
> p_session_sid varchar2(64);
> p_session_serial varchar2(64);
> p_database_name varchar2(8);
> string_1 varchar2(2000);
>
> BEGIN
>
> /* Set Variables*/
> SELECT UPPER(SYS_CONTEXT('USERENV', 'SESSION_USER')) INTO
> p_session_user FROM DUAL;
> SELECT UPPER(SYS_CONTEXT('USERENV', 'SID')) INTO p_session_sid FROM
> DUAL;
> SELECT serial# INTO p_session_serial FROM v$session WHERE SID =
> p_session_sid;
> SELECT sys_context('USERENV', 'DB_NAME') INTO p_database_name FROM
> dual;
>
> string_1 := 'alter session set TRACEFILE_IDENTIFIER = ''trace_'||
> p_session_user||'''';
> EXECUTE IMMEDIATE string_1;
>
> IF (p_session_user = 'DTRAQ') THEN
> DBMS_MONITOR.SESSION_TRACE_ENABLE
> (p_session_sid,p_session_serial,TRUE,TRUE);
> END IF;
>
> END;
> /
>
> THanks.
No, because I can't get it to misbehave. It's tracing DTRAQ, no other
logins.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
