Questions tagged [audit-logging]

Audit-logging is the practice of keeping records of system activity

Audit-logging is the practice of keeping records of system activity. Audit logging does not contain information about the technical operation of a system, like print statements, but rather keeps track of discrete events that occur within a system. Examples are "User X accessed data Y at Time T", etc.

389 questions
0
votes
1 answer

application_name is not available in audit logs in SQL Server 2017

I am looking for a way to fetch client application name in audit logs in SQL Server. As per the MSDN page, it should be available from SQL Server 2017…
0
votes
1 answer

Audit failure 4625 during AcceptSecurityContext

I'm using the method AcceptSecurityContext (https://msdn.microsoft.com/en-us/library/windows/desktop/aa374708(v=vs.85).aspx) to establish a secure connection, but this seems to trigger (two) audit failure events in the Windows event log. The events…
Øystein Kolsrud
  • 359
  • 2
  • 16
0
votes
1 answer

Jenkins, vstest.console.exe, and PowerShell

Problem This is a bit of a two fold problem. I am working on a Job that runs unit tests found within a target project. I have two variants that I am working with and I am trying to get one of them to work properly. Variant A I am using the…
Brandon
  • 731
  • 2
  • 12
  • 29
0
votes
2 answers

Log explicit statements from a session user to Unified Auditing in Oracle 12c

Trying to log all actions / statements run by a specific session user on an Oracle 12c database, using the relatively new Unified Auditing logging evironnment. The audit policy is defined as the following: CREATE AUDIT POLICY log_test ACTIONS…
Jostein Topland
  • 990
  • 8
  • 16
0
votes
1 answer

ChangeTracker implementation with database first appraoch

Our company is new to using EF and I would appreciate any guidance/advise on our problem. In this project we are using EF 6, Visual Studio 2015, a database first approach and RESTful service(this is a RESTful API using JSON not a generic API, we…
BabyDoll
  • 263
  • 1
  • 4
  • 16
0
votes
1 answer

How to check audit trail size and flush or truncate audit trial?

We have Oracle database in our startup company and there is only 1GB space is left in the entire database, It will be occupied soon so What should be done to make space in database? Can we truncate or delete Audit trail records in the database? If…
user8353718
0
votes
1 answer

Remove Successful login information from SQL Server Log

I want to use Audit Log to store successful/failed login info and remove the same from SQL Server Log. This way I can segregate the information in a different log file and increase the readability of both log files (SQL Server Log and Audit Log…
Mr. K
  • 380
  • 3
  • 15
0
votes
1 answer

Can I add Diplo Audit Log Viewer to a defferent section

I'm using Diplo Audit Log Viewer in my umbraco project, when I download the package I get the log only in the developer section, where and how can I change the package so the audit log viewer will be display in a different section (not the…
Damkulul
  • 1,406
  • 2
  • 25
  • 59
0
votes
1 answer

Save Audit Sp in a proper format

I'm using a database trigger to save the stored procedure code after an alter. I get the code using the EventData info. My problem is that it's saving the code as plain text, so it's difficult to compare the code against other version of the…
0
votes
1 answer

PostgreSQL audit table design with Multiple "User types"

I'm trying to implement an Audit table design in PostgreSQL, where I have different types of user id's that can be audited. Let's say I have a table named admins (which belong to an organization), and table superadmins (which don't). CREATE TABLE…
Sean Gregory
  • 571
  • 2
  • 10
0
votes
0 answers

groovy.lang.MissingPropertyException: No such property: state for class: org.hibernate.event.spi.PreDeleteEvent

package products import fiscalYears.FiscalYear class Catagorie { String productCatagory; Date dateCreated Date lastUpdated String lastUpdatedBy String createdBy static constraints = { lastUpdatedBy nullable:…
ujjwol shrestha
  • 145
  • 1
  • 12
0
votes
2 answers

Find Google Cloud Platform Operations Performed by a User

Is there a way to track what Google Cloud Platform operations were performed by a user? We want to audit our costs and track usage accordingly. Edit: there's a Cloud SDK (gcloud) command: compute operations list that lists actions taken on Compute…
0
votes
2 answers

How do I get the SQL caller's SPID

I have a multi-user application which makes various calls to SQL to alter values in various tables. Some of those tables have triggers on them to audit changes. I have code in the trigger that attempts to match the SPID value, as returned by @@SPID,…
David Siegel
  • 221
  • 2
  • 19
0
votes
1 answer

MVC where does the code for logging go (in terms of flow) before coming to action methods

I need help with logging in terms of MVC flow. I have an securely authenticated Web API which people try to access. Because of restricted access to Web API methods, some people do not have access to it at all ([Authorize(roles=Admin)] and other role…
0
votes
1 answer

Clear logs from SQL Server Audit File

Is it possible to Clear SQL Server Audit File logs. I want to delete old logs by date but can't find a way to delete it both from interface and sql Query.
Abdul
  • 2,002
  • 7
  • 31
  • 65