Questions tagged [audit]

A set of processes or functionality that tracks changes to one or more components of a system, ensuring the completeness and accuracy of transaction processing, authorization, and validity of system operations.

Audit controls (in software development) are a series of procedures that track changes to systems or components of a larger system. The exact systems or components that are subject to audit are determined by the risk exposure of the overall system.

The most common types of audit controls are (see "Information technology audit" article on Wikipedia):

  • Data Capture Controls – ensures that all transactions are recorded in the application system, transactions are recorded only once, and rejected transactions are identified, controlled, corrected, and re-entered into the system.

  • Data Validation Controls – ensures that all transactions are properly valued.

  • Processing Controls – ensures the proper processing of transactions.

  • Output Controls – ensures that computer output is not distributed or displayed to unauthorized users.

  • Error Controls – ensures that errors are corrected and resubmitted to the application system at the correct point in processing.

Most of these controls are applied at the systems level. For example ACID compliant databases systems provide a level of data capture control.

You should tag your question with audit if you're asking about any of the following:

  1. Tracking changes to a system
  2. "Who did what" controls
  3. How to implement a "Maker-Checker" workflow

Questions related to general system logging of events and errors should not be tagged with audit.

1160 questions
-1
votes
2 answers

Bash: how to check if there is only one root id and all user UIDs are unique?

i have this bash script here that i'm trying to modify to check if there is only one root id, is it vulnerable and currently, this script only checks if there is a duplicate uid and display the users that shares the same uid. Thanks in advance!…
S.Smith
  • 35
  • 5
-1
votes
1 answer

How to keep track of everything with JPA/Hibernate?

I was wondering how I could keep track of what's going on with entities, like who created the user, when, when was it last accessed ? More than that, I would also like to know about previous changes. to keep it simple I'd like to keep track of every…
Seb
  • 3,602
  • 8
  • 36
  • 52
-1
votes
2 answers

Does SQL Server 2008 Enterprise Edition trial version supports clustering and auditing?

I am going to download SQL Server 2008 Enterprise Edition trial version, my doubt is does this trial version fully functional or some limited functionalities? Does it supports Audit and Clustering features?
nectar
  • 9,525
  • 36
  • 78
  • 100
-1
votes
1 answer

Best way for Audit in Spring

I am creating an application where users can create games. I am storing in the entity Game who was the user that created the game, I mean, the owner of the game. The entity Game has some relationships ONE_TO_ONE (RuleGame) and ONE_TO_MANY…
Pedro Gonzalez
  • 180
  • 1
  • 2
  • 11
-1
votes
1 answer

Oracle logoff trigger to get sql's executed by session

I have created a table which contains the host names of all the trusted sources. I have written a oracle log off trigger to fetch details of all the sql executed by that session if the connection's host is not amongst the snif_session table. I am…
anudeepks
  • 1,080
  • 1
  • 12
  • 23
-1
votes
1 answer

Bash Script to compare webserver uptime in server auditing not working

I am trying to write a script to automate my server auditing headaches. I need to check what webserver is running on a server and then find its uptime. But eventhough I am able to find out the webserver I can't compare it with the variable I have…
-1
votes
2 answers

How do compare Java objects and properly audit values on updates?

I have an application server that sends an array of record data to the client in response to a search. Prior to sending the data to the client, my thought is to have the server store the data in a session variable. When the user selects and then…
James
  • 2,876
  • 18
  • 72
  • 116
-2
votes
1 answer

Record actions on a terminal

I want to record actions that a user performs on a terminal. This includes actions that may be performed while the user may ssh to a remote host. It means that if a user runs ssh user@192.168.1.1 user@192.168.1.1's password: ls -ltr f1 f2…
FlAm3R1D3R
  • 41
  • 5
-2
votes
1 answer

How to prove NT AUTHORITY / NT SERVICE SQL accounts cannot be authenticated to?

Auditors are asking me to show them that NT AUTHORITY / NT SERVICE accounts (NT SERVICE\SQLWriter, NT SERVICE\Winmgmt, etc.) in our SQL databases. I was taught that they are service accounts and are non-interactive. Is there a way I can demonstrate…
enmasse
  • 143
  • 2
  • 13
-2
votes
1 answer

using triggers for audit columns

In my company, i am a java developer and we use hibernate orm. Data Architects wanted audit columns ( CREATE_DATE, CREATED_BY, UPDATE_DATE, UPDATED_BY ) for every table on every database, because of data related purposes. This seems a bit weird,…
irfangoren
  • 19
  • 3
-2
votes
2 answers

Auditing DML changes in Oracle

I want to log all tables changes in one table named Tables_History with one trigger for each table, and whithout addressing column names explicity, and according to the type of column. Because i have 50 tables that belonges to different projects.…
Mehran
  • 1
  • 1
-2
votes
1 answer

Name that blog entry - Modelling changes over time with two db columns only

I vaguely remember reading a blog entry (written by a well-known blogger I think) about how to model price changes over time, and that you could model most changes by saving two dates only (two columns in a db). The blog talked about prices on a…
Alexander Torstling
  • 18,552
  • 7
  • 62
  • 74
-2
votes
1 answer

Bash script to audit Cisco configuration

I'm currently writing a script to generate a report from cisco configuration for audit purposes. Using 'grep' command, I was able to successfully capture the global configurations. But the challenge is doing it per interface. For example, I want to…
beatnik
  • 1
  • 1
-2
votes
1 answer

SSAE 16 website Audit

Our client need to get our website audited for security SSAE-16. I am not aware of much about this SSAE-16. So, my question is, What areas got covered in this audit? I read some where, that it mostly relevant for data centers. Do, they need to audit…
Srikant
  • 21
  • 3
-3
votes
2 answers

Quality Audit Software applied to Free Software

I'm doing an investigation searching for quality audit software applied to free software but haven't not much luck so far. I already found information of software that make quality audit http://en.wikipedia.org/wiki/Computer-aided_audit_tools but…
Gabriel Muñumel
  • 1,876
  • 6
  • 34
  • 57
1 2 3
77
78