postgres how to revoke set command

Question

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.

Answer 1

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.