August 13, 2013 at 9:15 am
Hello,
is there way, to find out which client is connecting via Linked Server to a specific database and with specific UserID?
(UserID?...ClientID?...Date?)
Background:
The user no longer exists (Real Employee !!:w00t:, and therefore it must be deleted on the SQL server. However, there are applications in our Companie that have deposited in the connection string with the user password (also odbc-connect and Views).
We have a lot of tables in this Database, and we cannot put a Trigger on each table. And if the User sends a "SELECT"-Statement, the Trigger doesn't fire.
Thank you
BEST REGARDS
Nicole
😉
August 13, 2013 at 9:52 am
Have you looked at the native SQL Audit, I am pretty sure that you can do this using an audit specification. Be aware though that it can log a very large amount of information filling a disk very very quickly.
http://technet.microsoft.com/en-us/library/dd392015(v=sql.100).aspx
In SQL 2012 the extended events are more complete to allow for more specific auditing and limiting the result set in comparision to the private package that is in SQL 2008 which are only available to SQL audit.
MCITP SQL 2005, MCSA SQL 2012
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply