Re: Monitor user changes
From: Don Grover (dgrover_at_assoft.com.au)
Date: Thu, 10 Feb 2005 16:48:21 +1100
I actually mean't users logins, not user data
ie: I actually want to monitor if any more users have been add, deleted or
edited on/to any database.
I have this msql server that I need to monitor remotely by script/email when
any user/login changes are made
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> You can use a trigger on the tables you want to audit. Just
> look at the values in the deleted and inserted tables used
> by the triggers for before and after images of the rows. You
> can capture the date with GetDate() and the user with
> suser_sname. And then just insert that data into your audit
> You can find an example of this in the following article:
> On Thu, 10 Feb 2005 07:53:50 +1100, "Don Grover"
> <email@example.com> wrote:
>>I need to monitor sql user additions and changes and put login name and
>>change date into a user created table.
>>Is ther anyway I can do this from a trigger or sp.