Re: User and Login auditing

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/26/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Wed, 26 Jun 2002 10:29:15 -0600

You can use Profiler to do this. If you are on SQL Server
2000, look at Profiler and the Securiity Audit Event
classes. On SQL 7, you could still monitor for executions of
sp_grantdbaccess, sp_denydbaccess, sp_grantlogin,
sp_addlogin, and sp_denylogin.

-Sue

On Wed, 26 Jun 2002 13:17:59 -0700, "Gabriel"
<Lajma@fibertel.com.ar> wrote:

>Does anyone know how I can audit user and login adding, deleting and
>modification ?
>
>I need to know when and who is adding users and logins to my server and
>databases..
>
>I was thinking of triggers on sysuers and syslogins tables, but MS does not
>reccomend this...
>
>Any hints ??
>
>Thx
>
>Gabe
>

Relevant Pages

  • Re: Cant connect to SQL server in Windows XP SP2
    ... Thanks, I'm not sure how to turn on login auditing, but using profiler is a ... > monitor for login failures in Profiler. ... >>vague about sql server does not exist or access denied. ... >>Chris Pankhurst ...
    (microsoft.public.sqlserver.connect)
  • Retrieve the IP Address from a Failed Login Attempt
    ... Is there a way to configure SQL Server or even Profiler to ... save or retrieve the IP Address of the system failing to ... Login failed for user 'sa'. ...
    (microsoft.public.sqlserver.security)
  • Re: Audit Login Failed Event
    ... Audit Login option is limited with info on the structure of the Windows ... You can get more info, including comuter name, with Profiler. ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: The error log that ate the server!!!!!
    ... You can do this in profiler, but I suspect it would be more efficient to do ... Wayne Snyder, MCDBA, SQL Server MVP ... Since I can't intercept the login the best I ... > blowing up my error log. ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)