nmakb
Reputation: 1245
postgres how to revoke set command
Is it possible for a user to not be able to run set commands to change work_mem etc? Certain users are setting work_mem and parallel sessions to high values impacting other sessions, would like to disable/revoke set from users, please let me know.
Upvotes: 3
Views: 456
Answers (2)
Laurenz Albe
Reputation: 247270
No, this cannot be done. For that reason, don't give untrusted users the opportunity to run arbitrary SQL statements.
Upvotes: 0
pifor
Reputation: 7892
I have developed a extension that allows to customize SET statements: https://github.com/pierreforstmann/pg_set_level
Note that it only works for SET statement and does not take set_config() function into account.
Upvotes: 2
Related Questions
- PostgreSQL revoke privileges from column
- How do I cancel a bad command in Postgres (from terminal)?
- Revoking access to database does not seem to work
- How to Revoke Execute Privileges on Functions in PostgreSQL by Default
- How to undo changes in PostgreSQL
- How to revoke permissions of a specific field in PostgreSQL
- PostgreSQL: how to reset config parameter?
- Revert insert into postgres database
- Revoke permissions on PostgreSQL
- How do I change a setting in a postgresql