An audit trail (also called audit log) is a security-relevant chronological record, set of records, and/or destination and source of records that provide documentary evidence of the sequence of activities that have affected at any time a specific operation, procedure, or event.
Questions tagged [audit-trail]
296 questions
0
votes
1 answer
SQL Server 2016 audit capabilities
I have a typical web-application, very CRUD based. When certain tables or columns change, we need to store history information about it. This could e.g. be an AUDIT table containing new/old column values, timestamp, what table it relates to, name of…
user1340582
- 19,151
- 35
- 115
- 171
0
votes
1 answer
audit trail log maintenance
I need an advise for the Audit Trail of the Help Desk module for my application.
Customer wants to keep the the track of each and every changes in the help desk module of application. There are more then 40 fields on the help desk form(more cold be…
NoNaMe
- 6,020
- 30
- 82
- 110
0
votes
1 answer
Oracle - using SQL%ROWCOUNT for auditing purpose
So i have a .NET software that makes use of Oracle as its database platform. A report in this software will call upon procedures from the Oracle schema that will run a number of update/inserts/deletes/merges on the database.
Now from research i can…
EkeshOkor
- 109
- 2
- 10
0
votes
1 answer
Update clause in Audit Trail Trigger
I got this trigger as a tip and I would like to know how it works with updates. It is supposed to create a record everytime there is an update or insert action on my main table.
create trigger tblTriggerAuditRecord on tblOrders
after **update,…
JS_Diver
- 756
- 7
- 19
0
votes
1 answer
Running History on a Table
I have a table that contains customer info. Things like Phone number, address, age, and several different custom groupings. All of these things can change on any given day for any given customer. I have been asked to create something that would show…
Chad Portman
- 1,134
- 4
- 12
- 38
0
votes
1 answer
`sql/cyanaudit--1.0.0.sql', needed by `installdata'
i am trying to install Cyan Audit for my postgres db.
according to doc, i have download it but when i run make install it says,
/bin/mkdir -p '/usr/share/postgresql/9.3/extension'
/bin/mkdir -p '/usr/share/postgresql/9.3/extension'
/bin/mkdir -p…
Muhammad Taqi
- 5,356
- 7
- 36
- 61
0
votes
0 answers
Saving a Reason when editting/creating a record (MVC)
Can't seem to find information on this anywhere. I'm looking for something similar to this audit trails feature but I also want the user to be able to add a reason as to why they are making the change.
Basically I just want to add a partial view /…
Chris
- 805
- 6
- 19
0
votes
1 answer
How can I implement Audit4J in my Java GUI application
This is my first time encountering Audit4J, and I'm wondering how I can implement that in my Java GUI project. I've tried reading the documentation in the website, but I wasn't able to grasp it concretely, and I've also seen the sample project for…
Eldon Hipolito
- 704
- 1
- 8
- 24
0
votes
0 answers
SCD (Slowly changing dimension) database model example. This one make sense and perform well?
On a customer loopback.io project I need to track/audit and provide undo/redo capability, the best I found was the SCD method.
I found something here: https://en.wikipedia.org/wiki/Slowly_changing_dimension then I created this model:…
newway
- 647
- 1
- 13
- 21
0
votes
0 answers
How to design CREATED and LAST UPDATED information in a USERS table?
I am trying to design a table for maintaining USER information. Here is the table design as per the below image
Since the table has created_by and last_updated_by columns and they are the foreign keys to the user_id column of the same table, I am…
Naveen P.G.
- 9
- 3
0
votes
0 answers
How to enable auditing in postgres?
In SQL SERVER 2008/12, we can create audit log under Security Tab using audit specification as
How can we have this in postgres 9.3 ? Or how can we track and view logs in postgres 9.3?
I want to track all the statement/scripts that runs in server…
Bunzitop
- 194
- 5
- 19
0
votes
1 answer
How to implement covert SQL Records Change Audit-Trail
My company wanted to implement audits for a SQL Server database. The result of combining quite a few really good solutions found on SO I wound up with the following:
An interface:
public interface IAuditable
{
string CreatedBy { get; set; }
…
Randy
- 1,137
- 16
- 49
0
votes
1 answer
Access 2010 - Audit Trail with composite primary keys
I have been unable to find a solution to this problem, so I hope some of you may be of help. I'm trying to create an Audit Trail for an Access database to track changes. Many of my tables have composite primary keys (multiple fields combined to…
Tiffany
- 301
- 1
- 2
- 12
0
votes
1 answer
What is better to use out-of-the-box Audit Trail or custom?
What can you recommend to me out-of-the-box Audit Trail or custom?
What are advantages and disadvantages of implementation of each of them?
0
votes
2 answers
How can I keep a log of users logging in and out?
I am creating an admin panel to log breakdowns, save tasks, log errors and much more. I currently have the following piece of code at the top of the screen which checks if a user is logged in, if not they are sent to the login / create a user…
nlangerdev
- 122
- 15