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 |
|
RobMarsh
Starting Member
28 Posts |
 Posted - 2002-09-05 : 13:09:11
|
| Is there anyway to get 'who did what' style details out ofSQL Server? This would be for admin changes as well as changes brought about by normal users.I havea Security department that would like to know if I can get this sort of detail for database change auditing purposes.I don't really know of any system tables that hold this information, and all I can think of are the logs, which don't hold much of the sort of info I'm after.Is there any other place to look?Thanks,Rob Marsh |
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2002-09-05 : 14:11:20
|
| You can put a trigger on each table you want to audit, in the trigger code you'll put the info of the one who made the transaction in a table for that use |
 |
|
|
|
|
|
Auditing actions