October 23, 2013 at 6:30 am
Is there a way to track if user was deleted from or Added to sql server?
Is it possible to set an alert if user is deleted from or added to SQL server?
October 23, 2013 at 6:54 am
I assume that you want to log changes of login settings on the server level. If I'm correct then you can do it with server level DDL trigger for events create_login, drop_login and alter_login. If you want to log modification for database's users you can create database level DDL trigger on database level for create_user, drop_user and alter_user.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 23, 2013 at 7:01 am
How do you create these triggers? and add alert to that trigger?
October 23, 2013 at 7:16 am
mandavli (10/23/2013)
How do you create these triggers? and add alert to that trigger?
See http://technet.microsoft.com/en-us/library/ms186406(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply