Post reply

audit table

  • December 10, 2008 at 9:18 am

    #198823

    Hi,

    I have a table with few columns containing sensitive data

    which are encrypted.Can i can a log table which captures

    any update delete to that columns

  • December 10, 2008 at 9:34 am

    #910485

    Yes you can;

    you can setup an audit table and use triggers to populate this table when changes are made.

    Or if you are using stored procs to access your data, you can modify these procs to write to the audit table when changes are made.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply