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.
| Author |
Topic |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2010-07-27 : 12:55:09
|
| Hi,We have a requirement where we need to audit the user actions (In this scenario it is SQL Server user and not a windows user), for example the following events:• Procedures executed by user• Queries ran by user or underlying objects queried by user• Logon/logoff from SQL ServerWhat are the possible options in SQL Server 2005?Thanks |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-27 : 13:41:47
|
| some can be traced with SQL Tracer, logon and logoff to sql server can be traced with third-party windows application or server application for tracking usage and costs - e.g.: Quest. |
 |
|
|
|
|
|
How to audit user actions