The audit-trail tag has no wiki summary.
3
votes
0answers
109 views
Preferred Methods Of Indexing MS SQL Server Audit Data To Splunk
What is your preferred method for indexing MS SQL Server for Splunk? I am collecting audit data in various environments by various means (profiler, app logs, and extended events) but I hope to ...
7
votes
2answers
250 views
Finding delete or update records
I have had three incidents in recent months where records in a table that have either been deleted or values updated to zero across a whole table. We have a team of four people who have the ...
2
votes
1answer
349 views
hstore for versioning fields in postgresql
I have a postgresql database that will hold about 50 tables, each of them having about 15 fields, it would have at least 300.000 rows on each table.
In order to track the changes done on each field I ...
2
votes
3answers
4k views
ORA-09925: Unable to create audit trail file
I'm using Oracle 11.1.0.6.0 db, on Linux 64 bit server on Amazon cloud.
I'm getting following error when I run the connect command
SQL> connect / as sysdba
ERROR:
ORA-09925: Unable to create ...
1
vote
1answer
409 views
Audit Logins on PostgreSQL 9.0
I have setup a script, created from various links on the web to trace activity in a table using a trigger.
/* Create the MinUser Table */
CREATE TABLE MinUser (
User_Id int NOT NULL ...
1
vote
1answer
822 views
What are some good methods of structuring a MySQL audit trail to be both immutable, and perform well for usage?
In one application, we have an audit table that uses the ArchiveEngine in conjunction with a few triggers to capture 100% of the changes that occur. The upside to this is that 20+ million rows ...
2
votes
3answers
928 views
What are the best practices for triggers to maintain a revision number on records?
I have an audit trail implemented on an application database that captures old value, new value, modification time, and user inserting it into another table. I'm now wanting to add a revision number ...
