Re: auditing database/server activities

From: Steve Troxell (steve_troxell_at_nospam.hotmail.com)
Date: 09/25/04

  • Next message: Jos: "Best practise for SQL Server 2000 Security" 
    Date: Sat, 25 Sep 2004 04:09:10 -0400

    jason wrote:
    > with increased concern of security these days. what are people using
    > to audit the activities on a sql server database?
    >
    > if they use in the box tools, is the audit trail managable?
    >
    > are people using a 3rd party tool to do sql server auditing?

    You could have a look at our OmniAudit product to create an audit trail of
    any data inserts, updates, or deletes.

    http://www.krell-software.com 

    -- 
Steve Troxell
  • Next message: Jos: "Best practise for SQL Server 2000 Security"

    Relevant Pages

    • Re: One Web Service updates SQL, another cant?
      ... In the profiler, in the Events tab, click on Security Audit. ... Columnist, SQL Server Professional ... And then I start getting the database closed errors on subsequent calls. ... >>> thing to look at is the permissions for that user in EM. ...
      (microsoft.public.sqlserver.security)
    • Re: file backup component
      ... Otherwise you can try to use audit techniques to find out who's trying to access the LDF file. ... file backup app or any other app that need LDF file a while. ... he meant something that belongs to the SQL server itself. ... Delay the start of the SQL server service until manual start. ...
      (microsoft.public.windowsxp.embedded)
    • Re: Audit logging an adp
      ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Multiple Instances - Properties tuning
      ... Why do you want to install mutiple instances of SQL Server since you have ... memory usage for each instance of SQL Server. ... would you yourself choose to audit All or None? ... > If I were to audit, would I benefit from only auditing failure, or ...
      (microsoft.public.sqlserver.server)
    • RE: Multiple Instances - Properties tuning
      ... Why do you want to install mutiple instances of SQL Server since you have only 1 GB of physical ... memory usage for each instance of SQL Server. ... would you yourself choose to audit All or None? ... > If I were to audit, would I benefit from only auditing failure, or ...
      (microsoft.public.sqlserver.server)