audit
Trying to audit deletions with a half baked system
My ERP system has a half baked deletion tracking system which inserts the following info into a table called M2MDeleteLog. I have left out unnecessary columns such as RecordId for simplicity.[详细]
2022-12-15 22:09 分类:问答Database design for audit logging [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.[详细]
2022-12-15 20:09 分类:问答Auditing Exchange 2007 Mailbox Full Access Permissions with Powershell
I on occasion I get asked to produce a list of users who have Full Access rights to a par开发者_如何学运维ticular Exchange 2007 Mailbox. At the moment I am doing this manually, and I\'d ideally like t[详细]
2022-12-15 14:50 分类:问答Creating audit triggers in SQL Server
I need to implement change tracking on two tables in my SQL Server 2005 database.I need to audit additions, deletions, updates (with detail on what was updated).I was planning on using a trigger to do[详细]
2022-12-15 00:42 分类:问答MySQL auto-store datetime for each row
In MySQL, I\'m sick of adding the columns dt_created and dt_modified (which are date tim开发者_运维问答e stamps for creation and last modified respectively) to all the tables I have in my database.[详细]
2022-12-14 22:02 分类:问答Tracking a Change on a Column
I recently ran across a very interesting problem involving database design. I have changed the table names to simplify the problem, so let me describe it as such:[详细]
2022-12-13 12:03 分类:问答How to write Audit methods in Java? [closed]
It's difficult to tell what is being asked here. This question is amb开发者_开发知识库iguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current for[详细]
2022-12-11 19:44 分类:问答Linq to SQL mapping data without a DataContext
Is it possible to access Linq to SQL mapping data without a DataContext instance? I ask because I am writing some audit data generation code that will only trigger for some entities and some entity c[详细]
2022-12-11 15:17 分类:问答database audit table
I have an existing application that I am working w/ and the customer has defined the table structure they would like for an audit log.It has the following columns:[详细]
2022-12-11 12:22 分类:问答