Postgres Pro
Downloads
Home   >   mailing lists

Re: system variable can be edited by all user? - Mailing list pgsql-general

From Pierre Forstmann
Subject Re: system variable can be edited by all user?
Date
Msg-id CAM-sOH-eEC69+f-znsWwtOCrYsvN3DTGJkcssNYL4Pjm7viKow@mail.gmail.com
Whole thread Raw
In response to system variable can be edited by all user?  (chris navarroza <canavarroza.work@gmail.com>)
List pgsql-general
Tree view
Hello,

You ccan try to use my extension pg_set_acl: https://github.com/pierreforstmann/pg_set_acl


Le mar. 22 nov. 2022 à 09:07, chris navarroza <canavarroza.work@gmail.com> a écrit :
Hi, 

Ive created a read only user (SELECT PRIVILEGE) but it turns out that this user can do this queries: SHOW work_mem; SET work_mem='40MB'; How do I limit him?

Thanks,

Butching

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Practical maximum max_locks_per_transaction?
Next
From: Andrus
Date:
Subject: WAL contains references to invalid pages in hot standby