Comments (2)
dwsteele
commented on May 20, 2024
Well, that certainly doesn't look right.
So, to be clear, this audit record is showing up even though it should not be based on the permissions given to auditor, i.e. there are too many audit records rather than too few.
from pgaudit.
dwsteele
commented on May 20, 2024
Any delete/update contains an implied select on the table, and that's what pgaudit is picking up on. It also happens for deletes if there is a where clause.
It might be possible to filter this out, but I'm not sure what unintended consequences that would have, or even if it would be correct. Any thoughts @sfrost?
from pgaudit.
Related Issues (20)
- ERROR: could not find function "pgaudit_ddl_command_end" in file "C:/Program Files/PostgreSQL/13/lib/pgaudit.dll.
- Revoking SELECT from the audit role does not disable read object audit logging for that relation HOT 5
- Audit log csv by pgaudit version 1.6.2 has 3 extra columns HOT 11
- SegV error from log_select_dml() HOT 5
- Help: How to save logs into database?
- password visible during create user and grant role simultaneously via pgadmin HOT 15
- PostgreSQL 16 support HOT 11
- log_catalog is off, but still some catalog SQL is logged HOT 3
- Unable to find required files
- Bad search_path in extension script HOT 2
- Unable to install pgaudit on RHEL 8
- Pgaudit make command fails for REL_13_STABLE
- Connection Drop and PgAudit disabled HOT 5
- Exclude role/user in auditing when superuser role is not available HOT 1
- PgAudit stack is not empty HOT 1
- Multiple errors : Generating during creation of pgaudit.dll
- number of effected rows HOT 1
- Redirect audit output HOT 1
- os x install (brew postgresql 14): permission denied error HOT 2
- Need only Object Audit Logging in audit logs HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgaudit.