Questions tagged [audit]
Database auditing involves observing a database so as to be aware of the actions of database users.
411
questions
1
vote
0
answers
23
views
How to audit server settings configuration changes other than view server state?
I want to capture the audit of server configuration settings changes.
For this I setup the SERVER_OPERATION_GROUP audit event.
This event is raised when Security Audit operations such as altering
...
- 3,476
1
vote
0
answers
91
views
SQL Server must provide an immediate real-time alert of all audit log failures (SV-213985r855969_rule)
My team has been trying to implement STIG:
SQL Server must provide an immediate real-time alert to appropriate support staff of all audit log failures (SV-213985r855969_rule).
Obviously, email ...
- 11
0
votes
1
answer
32
views
are pg_cron and pgaudit database specific extensions? or is one installation per server enough?
I'm quite versed in postgresql, but new to any extension other than postgis. for example, one of the first things I do when setting up an instance is to install postgis in template1, so it's available ...
- 183
0
votes
0
answers
44
views
How to import Oracle unified audit spillover files generated by Data Guard physical standby database without switching over?
I know that I can use the DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES procedure to load the unified audit spillover files (*.bin) into the internal unified audit tables in an Oracle 19c database. But, ...
- 101
0
votes
0
answers
33
views
Audit attempts to access the Database, only failed for some users and all attempts for the rest
I am needing help to be able to configure an audit mechanism that allows me to record in the audit_trail the login (or create session) attempts in my databases, the problem comes when I need to record ...
- 149
0
votes
1
answer
70
views
I can not read sqlaudit file generated in SQL 2019 from SQL2016
I am trying to read xxx.sql audit file(which has been generated by sql 2019) form sql server 2016 version and I am getting below error:
Msg 33201, Level 17, State 1, Line 31
An error occurred in ...
0
votes
1
answer
36
views
Point-in-Time-Recovery of Postgres at an arbitrary time for audit purposes [closed]
TL;DR
Would you recommend using CDC or pg_wal-based recovery to reproduce the state of the database in an arbitrary time, or stick with joining SCD2 tables (with start end end date for every record) ...
0
votes
0
answers
21
views
Creating a server audit specification through SSMS: what is the correlation between Audit Action Type and other columns?
Having gone through https://learn.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-server-audit-specification?view=sql-server-ver15 where it explains how to ...
- 13
0
votes
0
answers
13
views
can't create database audit always on contained 2022
I've created a server audit with the same guid on each node.
Then when I connect to the listener and I want to create an database audit with ssms it does not see the server audit.
If I create it on ...
- 1
0
votes
0
answers
81
views
SQL Server Database Audit used with a trigger to monitor CREATE TABLE events
Got SQL Audit enabled on a database with SQL Server 2016 SP1. Trying to catch a CREATE TABLE event with a trigger, and add that table to the audit to log data operations.
Problem is that changes to ...
- 994
0
votes
1
answer
102
views
Auditing for direct Object Access (Skipping indirect access)
to isolate internal tables from third party database access, we've created schemas specifically for that use case. Third party Logins/DB Users only have access to those "public" Schemas.
The ...
- 27
0
votes
1
answer
84
views
How do you correlate SQL Database Audit spec's log column transaction_id with a LSN? from trans log or CDC capture table?
How do you correlate SQL Database Audit log column "transaction_id" with a LSN either from the trans log or a CDC capture table?
I am trying to do this because cdc only captures the data ...
- 1
0
votes
0
answers
44
views
sqlserver alwayson audit setting
I am running SQLSERVER ALWAYS ON 2019 ENT VERSION.
I'm trying to STOCK an audit at the database level in SQLSERVER.
In the master, it was confirmed that the log audit was left at DATABASE LEVEL.
...
dante
0
votes
2
answers
475
views
Why password return null for table master.. sys.logins? *SQL Server
I have made comparison between two sql servers on my environments
A - SQL SERVER 2016 - Passowrd return value
B - SQL SERVER 2019 - Password is null
Is there any setting to check.
Thank you in ...
- 11
0
votes
1
answer
44
views
Automatic ID and Created/Modified By/Datetime fields?
Is it possible to get MySQL to automagically create and manage a record ID, Created By/Datetime and Modified By/Datetime columns for all tables in a database?
Note: Not looking to manually create ...
- 1