Audit trail for web application

From: Parag (parag_kulkarni_at_persistent.co.in)
Date: 06/21/05

  • Next message: dl: "SSL How-TO" 
    Date: Tue, 21 Jun 2005 12:04:12 +0530

    Hello,
    I have been assigned the task to design the audit trail for the ASP.NET web
    application. I don't know what the best practices for such audit trails are.
    Our application one dedicated user name and password to perform the database
    operations. I need to capture all the operations which are performed on the
    database. Also I need to able to capture the operations which directly
    performed on the backend directly using the tools like enterprise manager,
    query analyzer, etc. And also the data for the action should be captured in
    some set of tables, but not in the form of BLOB, so that if the admin want
    to know what are the various things the user did during the particular
    session then that should be reproduced in the form of report. Does any
    anybody have any idea of how to do such task? Any tips will be helpful.

    I am trying one approach with the help of triggers. But the problem with
    this approach is that I am not able to store all the information need to
    reproduce the same output if I try to generate report for the particular
    session.

    Thanks and Regards,
    Parag Kulkarni,
    India
    Email parag_kulkarni@persistent.co.in

  • Next message: dl: "SSL How-TO"

    Relevant Pages

    • Re: Audit trail for web application
      ... Can you please tell me what are the best practices ... that are followed in web application in .NET to implement the Audit trail? ... There are also 3rd party database auditing tools that should do ... Also I need to able to capture the operations which directly ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • Auditing and reporting
      ... We would like an audit trail of work carried out on the AD so that a report ... could be produced say on a monthly basis for the manager. ... but no in a form we can summarize and show to the manager. ...
      (microsoft.public.windows.server.general)
    • Re: data / record duplication multiuser dbase
      ... This was exactly the reason why I originally suggested to enable some ... sort of audit trail by adding 2 fields to capture who and when ...
      (comp.databases.ms-access)