Re: User and Login auditing

From: Gabe (Lajma@fibertel.com.ar)
Date: 06/26/02 

From: "Gabe" <Lajma@fibertel.com.ar>
Date: Wed, 26 Jun 2002 13:49:11 -0700

Thx Sue, but I need to constantly be notified when someone
adds/modidesd/delete a user or login. Thats why I was thinking of triggers
insted of Profiler, since I dont want to run Profiler on a minute to minute
basis....

I would like to be able to report what users and logins I had yesterday and
compare them to todays
users and logins. I suppose I have to track these changes with user defines
tables right ?

It would be easier with Triggers on sysuers and syslogin,s but I have never
seen anyone do this and besides, MS does not reccomend it...

Any suggestions ?

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:skqjhukqio6htda4r15h8purgdprptkbas@4ax.com...
> 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: Tracking Data Changes
    ... > inserts, deletes, and updates. ... Using SQL Profiler doesn't really do what ... > I thought about using triggers and the inserted/deleted tables to move the ...
    (microsoft.public.sqlserver.programming)
  • Re: How to know which tables is updated ?
    ... You could use profiler to audit certain types of activity & subsequently see what activity has occured through time. ... You could use triggers &/or default values to maintain a list of who & when records are added. ... is there any utility in Sql Server 2000 or any kind of third party tool available? ...
    (microsoft.public.sqlserver.server)
  • Tracking data changes
    ... inserts, deletes, and updates. ... Using SQL Profiler doesn't really do what I ... I thought about using triggers and the inserted/deleted tables to move the ...
    (microsoft.public.sqlserver.datamining)
  • Tracking Data Changes
    ... inserts, deletes, and updates. ... Using SQL Profiler doesn't really do what I ... I thought about using triggers and the inserted/deleted tables to move the ...
    (microsoft.public.sqlserver.programming)
  • Re: a rookie question about sp_helptext
    ... See example H in the documentation of "ALTER TABLE" in SQL Server Books ... My idea is to store triggers' creation codes in a seperate table using ... thread) is stored in table LOGINS where column USER= id of logged in user; ... a value @@SPID in LOGINS is being cleared. ...
    (microsoft.public.sqlserver.programming)