Stack Overflow
Stack Overflow

Questions tagged [audit-trail]

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.

296 questions
0
votes
3 answers

Exclude Cell Range from Worksheet_Change function

I'm currently trying to set up a spread sheet which will allow me to keep a track of each time someone in the office changes any information within it, I have got this to work via the following code:- Dim PreviousValue Private Sub…
BenC
  • 35
  • 13
0
votes
1 answer

Oracle trigger audit - How to log App user

I'm constructing a website. In this website, people will be able to manipulate several DB tables data. Everytime someone wants to make a CUD operation I want to log it (like and audit). The way I see it, I should use triggers for CUD operations, but…
FEST
  • 813
  • 2
  • 14
  • 37
0
votes
0 answers

Audit trail for established Access database

Good Evening all I have inherited an Access database that is now running on Access 2010, there is currently no Audit trail for this dB and it's quite important that it has one. I've read various articles that suggest a fairly neat solution based on…
Ian Hollis
  • 21
  • 3
0
votes
1 answer

Error: Data too long for column "story_html"

I am using gem "audited-activerecord", i have a column called "story_html" in a table and it saves the html5 contents. when i update the "story_html", i get the following error:- Mysql2::Error: Data too long for column 'story_html' at row 1: UPDATE…
Mano
  • 979
  • 1
  • 18
  • 36
0
votes
0 answers

SQL tracking changes

Hi i have a view that contains: ITEMID ITEMNAME STATUS 1001 BRICKS 1 And the table is updatated to: ITEMID ITEMNAME STATUS 1001 BRICKS1111 1 and i want that status automaticaly would change to 0 when update/insert is made (it can be made…
user2893780
  • 121
  • 1
  • 2
  • 9
0
votes
2 answers

Sybase query to retrieve dba activity

I am new to Sybase ASE, I needed help in crafting a query which will retrieve from the Sybase database the database administrator activity (specific db users). DBA has informed that the auditing has been enabled on the Sybase database. The logging…
Potta Pitot
  • 175
  • 1
  • 5
  • 15
0
votes
1 answer

Audit sessions to Dynamics CRM 4

I'm looking for information about how to audit logins to Dynamics CRM 4. This is an on premise site, and use Active Directory for authentication. I'm currently evaluating two choices: 1- Create a custom http handler and create a handler for…
Oscar
  • 13,594
  • 8
  • 47
  • 75
0
votes
1 answer

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? I would like to use a simple database trigger to write to an audit table but I am unsure of how I would be able…
Adonis L
  • 1,679
  • 4
  • 20
  • 23
0
votes
1 answer

Dynamically Build UPDATE statement within INSERT/UPDATE/DELETE trigger

basically i am looking for logic to generate insert or update statement in string variable from trigger. suppose when people just update 'N' of fields like update statement....then my trigger will fire and from that trigger i want build what update…
Thomas
  • 33,544
  • 126
  • 357
  • 626
0
votes
1 answer

Audit Trail for unbound forms/textboxes

I have been searching for days for ways on how to implement an audit trail in my access 2010 database. There are plenty of solutions out there that work great when the form is bound, but I have several forms that are unbound and perform certain…
Mgogan
  • 55
  • 2
  • 11
0
votes
1 answer

Performance impact when creating Audit trail using trigger in MS SQL Server 2012

In SQL Server 2012 database we want to create audit trail for almost all major tables on Update and Delete operations.Noramally we creating Audit Trail using trigger on each table and store it on shadow table. So there is any performance impact? if…
user3588074
  • 1
  • 4
0
votes
1 answer

How to trace the history of changes to each data in ax2012

i'm looking for how AX2012 manage Traceability . I must trace the history of changes to each data (modification date, user ID, IP address of the workstation). I must also find all the changes made by a given user in a given period and for…
Ahmed
  • 259
  • 2
  • 9
  • 26
0
votes
1 answer

Receiving a fatal error related to an extension that was removed

I removed the entire extension. This error showed up. I even replaced the entire application files. It still showed up. I searched AuditFieldBehavior, nothing showed up. Any ideas where I can look next? AuditFieldBehavior is the class that extends…
hammies
  • 1,344
  • 2
  • 22
  • 46
0
votes
1 answer

Log amount of data sent back from mysql after php call

If I have a PHP script that makes a MySQL call/query. Is there a way to log/audit the size of the response/data (in bytes) that is returned from that call? I know I could use tcpdump, but that does not necessarily ensure the traffic stats I gather…
WildBill
  • 9,143
  • 15
  • 63
  • 87
0
votes
1 answer

Mysql - Select To XML

I'm Building Audit Trail with Trigger, and want to convert the inserted / updated / deleted value into XML and store it into another table. my trigger look like this: DELIMITER $$ CREATE TRIGGER `MyDB`.`TriggerAudit` AFTER INSERT ON…
reptildarat
  • 1,036
  • 2
  • 18
  • 35
1 2 3
…
19 20