system variable can be edited by all user?

From: chris navarroza <canavarroza(dot)work(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: system variable can be edited by all user?
Date: 2022-11-22 06:25:31
Message-ID: CADRdQ7qAWHV1GHuofQGn4kn5pM4T5W5JsuNSOk8AkZ-Otpm_8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2022-11-22 08:43:04 Re: system variable can be edited by all user?
Previous Message David G. Johnston 2022-11-22 00:49:42 Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?