[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: system variable can be edited by all user?
From:       Pierre Forstmann <pierre.forstmann () gmail ! com>
Date:       2022-11-26 9:14:03
Message-ID: CAM-sOH-eEC69+f-znsWwtOCrYsvN3DTGJkcssNYL4Pjm7viKow () mail ! gmail ! com
[Download RAW message or body]

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

[Attachment #3 (text/html)]

<div dir="ltr"><div>Hello,</div><div><br></div><div>You ccan try to use my extension \
pg_set_acl: <a href="https://github.com/pierreforstmann/pg_set_acl">https://github.com/pierreforstmann/pg_set_acl</a></div><div><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">Le  mar. 22 nov. 2022 Ã   \
09:07, chris navarroza &lt;<a \
href="mailto:canavarroza.work@gmail.com">canavarroza.work@gmail.com</a>&gt; a écrit  \
:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi,  \
<br><br>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=&#39;40MB&#39;; How do I limit \
him?<br clear="all"><div><div dir="ltr"><div \
dir="ltr"><div><br></div>Thanks,<div><br><div><span \
style="color:rgb(34,34,34)">Butching</span><br \
style="color:rgb(34,34,34)"><br></div></div></div></div></div></div> \
</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]