audit-tables
SQL-Server Trigger on update for Audit
I can\'t find an easy/generic way to register to an audit table the columns changed on some ta开发者_StackOverflowbles.[详细]
2023-04-11 02:02 分类:问答How do I write to an external audit database in SQL Server 2008?
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.[详细]
2023-03-19 13:15 分类:问答Data history tracking best practice
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.[详细]
2023-03-19 09:48 分类:问答How to design a SQL db with undo-redo?
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:[详细]
2023-02-19 16:24 分类:问答Updating a table (with audit trigger using Service Broker) in a Transaction
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[详细]
2023-02-15 06:19 分类:问答"audit create session by session" vs. "audit create session by access"?
When I enabling au开发者_如何学编程diting for create session by the following way: audit create session by session;[详细]
2023-02-09 04:49 分类:问答Audit Table DB Design : Does creating Audit Tables for Join Tables make sense
we are creating separate audit tables for those entity tables which need auditing using triggers on PostgreSQL 8.4.[详细]
2023-01-07 23:34 分类:问答How to delete entries from my audit table?
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.[详细]
2022-12-29 19:24 分类:问答Web Application Auditing
How can I audit a web application specifically database changes, when the application is connecting to the database as a system account?[详细]
2022-12-25 07:18 分类:问答When is an agile iteration considered complete? [closed]
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[详细]
2022-12-16 15:27 分类:问答