Post reply

Tables and Records modification view

  • October 4, 2012 at 3:33 am

    #282519

    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

    #1545413

    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

    #1545422

    What is a custom audit and how to set/implement it?

  • October 4, 2012 at 3:47 am

    #1545425

    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