Re: system variable can be edited by all user?

[Pierre Forstmann <pierre.forstmann@xxxxxxxxx>]

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@xxxxxxxxx> 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