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
What Tables or Views for ORA- errors?
I need some help in auditing in Oracle. We have a database with many tables and we want to be able to audit every change made to any table in any field. However, I find it difficult to locate the descriptions for ERROR code. For example,
So my…
user3231051
0
votes
1 answer
How to retrieve the return code descriptions in oracle audit
I need some help in auditing in Oracle. We have a database with many tables and we want to be able to audit every change made to any table in any field. However, I find it difficult to locate the descriptions for return code. For example,
ORA-00020:…
user3231051
0
votes
2 answers
Easiest way to append a string with different values by checking if hiddenfields are empty
I'm building an audit trail in C#, asp.net. On the .aspx page I have several hidden fields which associate themselves with regular fields (i.e. txtFirstName -> firstNameTrackerHiddenField). I have it set up so that when the user inputs/selects data…
Brian W
- 21
- 1
- 8
0
votes
1 answer
Audit Trail Trigger generation
Working on Audit Trail system and decided to do it with Shadow/History table with triggers.
Followed this Audit Trail Article and trying to use CodeSmith Generator tool
I dont understand how it creates the history table and the trigger.
Is any one…
Billa
- 5,226
- 23
- 61
- 105
0
votes
1 answer
Create an audit trail using paper_trail gem
I'm pretty new to rails, and brand new to using the paper_trail gem.
I would like to show a list of each change made to the location or tag number of my assets model. I have installed paper_trail and it seems to be working correctly. In my view I…
user1339113
- 65
- 2
- 9
0
votes
1 answer
How to create audit trail for a table using Triggers. I am using sybase 15.2 ASE
Iwant to post all changes of records of table copied into a separate table
CREATE TABLE dbo.mytable(
field1 numeric(13,2) NOT NULL,
field2 char(4) NOT NULL,
field3 char(4) NOT NULL,
field4 varchar(30) NOT NULL,
…
niru dyogi
- 619
- 5
- 14
- 37
0
votes
1 answer
QuickBooks Online (QBO) API Retrieve Deleted Bills
Does the QuickBooks Online (QBO) API have the ability to query for objects that have been deleted? For example, I would like to query for bills that have been deleted.
0
votes
1 answer
What are differences between audit action groups of AUDIT SPECIFICATION and audit event class of sql tracer in Microsoft SQL Server?
I want to know differences between audit action groups of AUDIT SPECIFICATION and audit event class of SQL Tracer in Microsoft SQL Server.
I intend to implement a logging program by setting audit event class through sp_trace_setevent…
user1804694
- 121
- 1
- 5
0
votes
1 answer
I need C++ API similar to fn_get_audit_file procedure in Microsoft SQL Server 2008 R2
I want to programmatically read audit trail files(.sqlaudit) logged in SQL Server 2008 R2.
I wish they are be able to be viewed without using queries of SQL Server but with functions such as C++ API.
I want to implement an application program…
user1804694
- 121
- 1
- 5
0
votes
1 answer
Can I still use AuditReader when I have my own listeners in Envers?
I am trying to do conditional auditing with Envers so, according to documentation, I turned off default Envers event listeners and instead registered my own subclasses.
Now I'm trying to read audit tables with AuditReader but it throws an exception…
Bolek
- 1
- 3
0
votes
0 answers
Hibernate audit trail aganist user action?
we have requiremnet to log each user action and fields modifeid due to this action. Audit logging is implemented using the hibernate interceptor
Inorder to get the user action in the hibernate interceptor what would be the best approch
Sujith
- 1,127
- 1
- 13
- 20
0
votes
1 answer
MySQL audit trail using triggers and mysql session variables for web user_id. Good solution?
If I do an audit trail using triggers in MySQL, and I use MySQL session variables to store the PHP variables I need to store, something like:
SET @user_id = $user_id
SET @user_ip = $user_ip_address
and then use that information in the trigger, will…
F. A
- 111
- 1
- 10
0
votes
2 answers
Audit trail in SQL
Following is the problem statement:
I have a database table with entries that look like (this is fictional table :-) ):
Company Customer ID Date
Amazon 1 2012-08-30
Amazon 2 …
name_masked
- 9,544
- 41
- 118
- 172
0
votes
1 answer
Audit Trailing System in Oracle
I am trying to build an audit trailing system for my Oracle-Java application. I have done lots of search in Google. Found some solutions, mostly suggested to use trigger. But problem using this approach is I won't be able to track which application…
Somnath Guha
- 107
- 3
- 13
-1
votes
1 answer
Audit who deployed SQL database to Azure
Through SSMS, connecting to my on prem server, you can right click a database, select tasks and "DEPLOY DATABASE TO MICROSOFT AZURE SQL DATABASE". Is there a way to log/audit who did this from my on prem server?
After doing this, I've checked the…
Scott D
- 1
- 1