Monitoring database logons
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Monitoring database logons

  1. #1
    Join Date
    Jun 2001
    Location
    Dublin, Ireland
    Posts
    66

    Monitoring database logons

    Hi all,

    I would be grateful if anyone could help with this problem.
    I have a database that is accessed by many users through a third party application. If any users make changes or updates, the application provides full auditing, so I can see who changed what,when they changed it and from what terminal they made the changes.
    The problem I have is that changes can be made by someone accessing the database directly from an sql session. These cannot be recorded by the applications auditing function.
    Is there any way that Oracle can provide information on users who access the database directly and not through the application.
    I know that I can use Oracles auditing function, but I think that this will also record all access through the application as well.
    I dont need this duplication and I can also do without the additional load on the system.
    Oracle version is 8.0.6 (so I cant have logon/logoff trigger)

    Any help much appreciated.

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    In 8i, you need to set

    AUDIT_TRAIL and
    AUDIT_FILE_DEST

    in the initSID.ora file.

    Auditing login attempts is initiated with the command

    audit session; and turned off with
    noaudit session;

    Hope that helps
    David Knight
    OCP DBA 8i, 9i, 10g

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