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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-08-19 : 03:16:15
|
| Dear All,I am very new to SQL server administration and i have a few questions related to data auditing.so there are two ways to make changes to the data in the database1. User makes the change through the web application and then we capture this in the history table through trigger- No issues with this,2. 2. a person with SQL access can manually make a change to data in the database through SQL at the moment there is no audit trail for thisCan somebody help me to maintain audit trials for Point 2 so that i can track the changes made.Your comments will be very help full.Thanks,Gangadhar |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-19 : 04:06:08
|
| If you have a trigger on the table it will fire for (2) as well (unless someone deliberately disables the trigger).For Fraud (e.g. deliberate covering-of-tracks) you have database backups. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
|
|
|
Audit in SQL