Audit DBA accounts - reg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Audit DBA accounts - reg

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Audit DBA accounts - reg

    Running ORacle 9i Relase 1 on a windows box. The dba connections are audited in the Event viewer, by default. Is there any other way to audit the database DBA username, atleast during connection.

    The event viewer, only reports the os user logging in with sysdba/sysoper privs, I would also prefer the database username.

    TIA

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684

    Re: Audit DBA accounts - reg

    You can use a system level trigger to log all connections if you want. You might want to try something like:


    CREATE OR REPLACE TRIGGER logon_trg
    AFTER LOGON ON DATABASE
    BEGIN
    -- Audit the login.
    -- Gather data using the SYS_CONTEXT('USERENV', '???') function.
    END;
    /


    Note. Make sure you have a connection open constantly while testing system level triggers. If you make a mistake in a login trigger you might find yourself unable to reconnect.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width