DBA member updated the data. How to confirm that he did the update.

[jvskarthick]

Hi,

The person who is responsible for the database (DBA member at client place) updated the particular data in table . How to confirm that he did the update and what time? User name? Machine name?.

we can create the trigger on all the tables but (DBA member at client place) can disable and update the data. (so this is not sufficient one)
we can create the Change Data Capture CDC on all the tables but it’s not storing the User name and Machine name . (so this is not sufficient one)

In case if we want to prove that the particular person did the update/Delete/ Insert on table without trigger. How to do that?

Is that a way we can read the .LDF (log file) and conform that? How to read the log file?

Thanks,
JK

[ck9663]

When you say "at client place", do you mean the data is in your client side or he is in client office connecting to your sever? It would depend on where your db is, but a trigger should be sufficient.

~~ CK

[jvskarthick]

The server exists on client side. we are doing the support to them. Trigger (Client DBA) can diable and do the modification whatever he want to correct? is there any other way we can?

[ck9663]

There is a trigger called DDL Event Trigger. This is different from a database trigger. You can create one like it so only limited people can disable the database trigger. You can insert all updates to a table. You can use an IDENTITY column on that table so you'll know if someone delete a row. You can also make that table read-only by using a DDL Trigger. Or you can send an email to someone if someone change anything on your server, whether is a setting change or a data change.


Good Luck!!!

~~ CK