Stack Overflow
Stack Overflow

Questions tagged [auditing]

330 questions
2
votes
4 answers

Auditing in Database or Application

I need to audit modification actions (create/delete/update) in an enterprise web application. Then the user may need to see history of changes of a specific entity (a Person for example) to decide to do an action or not. As far as I know it can be…
Saber
  • 2,440
  • 1
  • 25
  • 40
2
votes
1 answer

How to log document changes on Windows Server 2008 with AD?

Ok so we have a team of developers working on files stored on a Windows Server 2008 R2, usually txt files. These developers log in remotely using their own username/password from the Active Directory on the server. They all have rwx access to a…
R.D.
  • 1,557
  • 2
  • 10
  • 11
2
votes
1 answer

ObjectContext's SavingChanges: find out which columns have changed?

I'm handling ObjectContext's SavingChanges event to timestamp entries. The requirement is that, if only ColumnA has changed, I don't timestamp the entry when it changes. Is there a way that I can find out which columns have changed (are changing)…
lance
  • 16,092
  • 19
  • 77
  • 136
2
votes
2 answers

How can I set a username for a Postgresql audit trigger?

I am using a trigger in PostgreSQL 8.2 to audit changes to a table: CREATE OR REPLACE FUNCTION update_issue_history() RETURNS trigger as $trig$ BEGIN INSERT INTO issue_history (username, issueid) VALUES ('fixed-username',…
Chris R
  • 17,546
  • 23
  • 105
  • 172
2
votes
1 answer

How does Win32_Product work?

While working on an auditing project I came across different problems regarding software and licenses. My project runs on Linux with Perl and I successfully retried remote machine software via both SNMP and WMI. The big issue is that the two…
raz3r
  • 3,071
  • 8
  • 44
  • 66
2
votes
2 answers

Deleting git branch loses audit

If a branch has been deleted in git is it still possible to identify whether specific commits were made on that deleted branch? From what I have found so far - git branches are merely pointers so deleting them would lose the that specific part of…
skword
  • 311
  • 2
  • 11
1
vote
1 answer

CentOS/auditd: file creation at directory to trigger a script

I need to audit the directory and call a script with the file-path parameter as the file is created there. Reading the man of auditctl i can't find a way to do it. There're references in the web to inotify or iwatch services, that should do what i…
A-Live
  • 8,904
  • 2
  • 39
  • 74
1
vote
0 answers

Checking Integrity of Data Entry

first post so please forgive me if I get it wrong. What I am looking for is a methodology or a standard for comparing data that is stored in a database and the original field data. We have a database which has been populated from field data and…
Peter Bedson
  • 11
  • 2
1
vote
1 answer

Monitoring Bandwith on a remote machine with WMI

I am trying to monitor interfaces bandwidth on a remote Windows machine. So far I used SNMP with the Cisco Bandwidth Formula but that requires to retrieve two samples at two different times. Last but not least it seems that the value I record with…
raz3r
  • 3,071
  • 8
  • 44
  • 66
1
vote
1 answer

EntityAudit - Doctrine2: Using the same entity in both OneToMany and OneToOne possible

is it possible do audit entities with the simplethings / EntityAudit - https://github.com/simplethings/EntityAudit using the same entity in both OneToMany and OneToOne relation? class Address { /** * @ORM\Column …
stefi
  • 111
  • 1
  • 6
1
vote
1 answer

User login auditing - best practices

As per of login auditing, I want to store http request related information in repository. One thing that comes in mind is the client IP address. Are there any other important fields from http request object that should be stored also? I want to do…
palm snow
  • 2,392
  • 4
  • 29
  • 49
1
vote
2 answers

How to monitor remote Linux machines and retrieve installed software in Perl?

I have a couple of Perl scripts that allow me to monitor remote Windows machinses through WMI. Right now I can check CPU usage, Memory usage, Disk usage and Installed Software. But what if I want to do the same job on a remote Linux machine?…
raz3r
  • 3,071
  • 8
  • 44
  • 66
1
vote
2 answers

Audit log (trail) tampering in databases

Lets say we have a application which has a database - MySQL, SQL Server, or Oracle, for example. And let's assume that we have multiple people, like db and audit administrators, who have admin access privileges to the database. Let's say one of the…
Aruna Karunarathna
  • 981
  • 2
  • 23
  • 55
1
vote
1 answer

Auditing in Oracle 12c

We want / need to audit all statements on a number of tables in one of our instances. So, we've enabled Unified Auditing. That appears to be working. We've created the policy, and we can see the DML & select statements in the UNIFIED_AUDIT_TRAIL…
Landon Statis
  • 683
  • 2
  • 10
  • 25
1
vote
1 answer

Logon trigger/ auditing method to identify the programs/packages/modules/procedures using sys/system connections

In my database many programs/modules uses sys/system connection to perform operations on data. eg: sys/ as sysdba perform dml's,ddl's or any user requirements. I want to replace this connection string with some other user . Is there any way to…
pavankumar2028
  • 43
  • 4
1 2 3
…
21 22