Alerting on New user add or permission change of any existing user

Question

Post reply

Alerting on New user add or permission change of any existing user

DKG

Ten Centuries

Points: 1183
More actions
July 8, 2008 at 12:05 pm

#126274

Alerting on New user add or permission change of any existing user.
I want the SQL Server to alert in case of any new user creation by some one or change in rights or existing users in sql server. This is required for some audit purpose. Server version could be 2000 or 2005.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 1

You can do this with DDL triggers on 2005. Not sure you can do this in 2000 without running a trace continuously.

DKG Ten Centuries Points: 1183 More actions · Answer 2

Could you let me know in details how to use that DDL triggers, and would it generate alerts so that i can triggered mails using operator.

MannySingh SSChampion Points: 12465 More actions · Answer 3

Yes you can set up the Triggers to sent out emails also.. TRY to REAd about DDL Triggers on BOL.

http://technet.microsoft.com/en-us/library/ms175941.aspx

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/2927/

Maninder
www.dbanation.com

DKG Ten Centuries Points: 1183 More actions · Answer 4

Thanks Mani.....

But for the other system tables in the master database (such as syslogins and sysdatabases), it's impossible to create triggers, so we should take another approach.

So wts the other approach....???