I can\'t find an easy/generic way to register to an audit table the columns changed on some ta开发者_StackOverflowbles.
I have a SQL Server 2008 database with 10 windows users who all have permissions to Insert, Update and Delete tables. Each table has a trigger that writes to an audit table in a different database.
we need to keep开发者_StackOverflow track of data modification during the time on some table. We need some advice about how to achieve this task. Wehavetwo streets to follow in our mind.
I\'m trying to figure out how to design my DB tables to allow Undo-Redo. Pretend you have a tasks table with the following structure:
We have implemented Auditing capability using service broker and have implemented triggers on the tables that need to be audited. The issue we are facing is when we try to update an auditable table fr
When I enabling au开发者_如何学编程diting for create session by the following way: audit create session by session;
we are creating separate audit tables for those entity tables which need auditing using triggers on PostgreSQL 8.4.
I am currently working with Hibernate Envers. How to delete entries in the audit table related to the entity I want to delete? My entity has no relation with other entities.
How can I audit a web application specifically database changes, when the application is connecting to the database as a system account?
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing
加载中,请稍侯......