Comments (8)
Are you auditing the postgres user? If so this is not recommended some filters won't work properly in this case.
from pgaudit.
We are auditing our personal users who have the following roles SUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION;
and they ask us to audit in this way!
ALTER ROLE xxx
SET pgaudit.log = 'all, -misc';
What do you recommmend me to do?
Thanks for your time
from pgaudit.
We recommend that you don't have all your users be superuser. Beyond that there's not much pgaudit can do.
from pgaudit.
It is that we are the dbas, but the client is wanting to audit all the users !!!
For that, they ask us to audit the nominated users
from pgaudit.
That is certainly your choice, but we have no way to reliably filter foreign key queries for the superuser. There are some logging tools (ELK, Splunk) etc. that can help with this if you want to create your own rules.
from pgaudit.
Perfect, we will communicate to those in charge of the subject that there is no possible solution, thank you very much !!!!
from pgaudit.
You should consider using the set_user extension instead of making all the DBAs superuser. DML run via set_user will still create the extra entries but it might reduce your logging overall.
You can also use grants to allow these users to run DML on tables that they frequently have a reason to modify instead of granting superuser.
from pgaudit.
thanks a lot David!
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.