October 4, 2012 at 3:33 am
Hi,
I have a critical database using multiple users,
some users edit some table data so i did not found to which user access and modify
so how to find the access user and PC/IP address and user modified data ,Data and time
October 4, 2012 at 3:35 am
Do you have custom auditing in place, which logs who acesses what and where from? If not you cannot find out who modified the data.
October 4, 2012 at 3:43 am
What is a custom audit and how to set/implement it?
October 4, 2012 at 3:47 am
If you have enterprise edition, you could look at change data capture (unsure if it captures the user and hostname), otherwise you will need to use things like triggers which capture any INSERT UPDATE DELETE statements users may execute.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply