RE: auditing database/server activities

From: Hari Prasad (HariPrasad_at_discussions.microsoft.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 11:45:08 -0700

Hi,

see the below links:-

http://www.microsoft.com/technet/security/prodtech/dbsql/sql2kaud.mspx

http://www.sql-server-performance.com/lockwoodtech_log_navigator_spotlight.asp

Thanks
Hari
MCDBA

"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?
>
> thanks

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)