User security

From: GeorgeP (GeorgeP_at_discussions.microsoft.com)
Date: 08/31/05

Next message: Keith G Hicks: "windows authentication question"
Previous message: John King: "Free Evaluation of Database Administration Software"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Wed, 31 Aug 2005 07:15:03 -0700

I was wondering since we cant add a trigger to sysusers or sysxlogins how can
I be notified when ever a new users is added to a SQL server or one is
modified in a Database?

TIA,
GP

Next message: Keith G Hicks: "windows authentication question"
Previous message: John King: "Free Evaluation of Database Administration Software"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: User security
... >I was wondering since we cant add a trigger to sysusers or sysxlogins how ... Dejan Sarka, SQL Server MVP ...
(microsoft.public.sqlserver.security)
Re: Who may create a trigger on SYSOBJECTS table
... You cant create triggers on system tables. ... > Is it possible to create a trigger on SYSOBJECT? ... > 1) Check if you are DBO: ...
(microsoft.public.sqlserver.programming)
Re: Trigger Error
... > You cant do this with the datatype ntext, text and image, because thse ... > so trigger will not get the the previous state of deleted or updated ... >> My trigger is to copy the entire record into an audit table on ...
(microsoft.public.sqlserver.programming)
Age of Mythology
... dead" condition "timer."It is possible to use more than ... one trigger and condition at the same time. ... P.S.Some triggers dont work in multiplayer,or at least i ... cant find a way to make them to. ...
(microsoft.public.games)