RE: logon trigger with machine condition

From: Bruce McCartney <bruce.mccartney_at_dbinfosystems.com>
Date: Tue, 1 Feb 2005 13:13:03 -0700
Message-Id: <200502012012.j11KClBx025618@mail79.megamailservers.com>

Jason,
I did a presentation (including code) on just that topic at IOUW last year. You can can download it from iouw (paper #500), or my web site. The technique allows you to enable it based on machine, program,osuseror many other attributes of v$session ...

Bruce
dbinfosystems.com/news.htm

-----Original Message-----

    From: "jsb_at_digistar.com"<jsb_at_digistar.com>     Sent: 2/1/05 12:35:08 PM
    To: "oracle-l_at_freelists.org"<oracle-l_at_freelists.org>     Subject: logon trigger with machine condition          

    I'm looking for a way to trace a session on logon with the condition that     it be from a particular host. Wolfgang brought up a good point about     logon to a particular schema but in this case I need a database-wide     trigger.          

    I'm looking to do something like this below, but it does not work:          

    CREATE OR REPLACE TRIGGER trace_a_session

       AFTER LOGON ON DATABASE
    BEGIN

       IF USER LIKE 'USER'
       THEN
          IF HOST LIKE 'SOMEHOST.DOMAIN.COM'
          THEN
             EXECUTE IMMEDIATE 'alter session set events ''10046 trace name
    context forever, level 12''';
          END IF;
       END IF;

    END;
    /               

    There apparently is no PL/SQL HOST function which is what I need, or a way     to do it via a nested select and variables. I intend to purchase a book     or two after work tonight but I need some help now if anyone has dealt     with this situation before.          

    regards,
    Jason
    --
    http://www.freelists.org/webpage/oracle-l     

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 01 2005 - 15:15:45 CST