Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Log User Access to Server and Database

Author  Topic 

gpc44
Starting Member

35 Posts

Posted - 2013-08-13 : 11:12:07
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?)
>> audit for select-activity in Database
Background:
The user no longer exists (Real Employee !! :( , 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

djj55
Constraint Violating Yak Guru

352 Posts

Posted - 2013-08-14 : 08:58:19
Look at audit trace. sp_trace_create
Not sure if that will get you what you want but it might.

djj
Go to Top of Page
   

- Advertisement -