MIME-Version: 1.0
References: <2094241112.614816.1745454418891.ref@mail.yahoo.com>
 <2094241112.614816.1745454418891@mail.yahoo.com>
In-Reply-To: <2094241112.614816.1745454418891@mail.yahoo.com>
From: Akshay Joshi <akshay.joshi@enterprisedb.com>
Date: Thu, 24 Apr 2025 11:02:33 +0530
Message-ID: 
 <CANxoLDdQE9JBqWFPQDOPrMQS_57qMm7j-pqeHvCAp1jJ4Q_3sg@mail.gmail.com>
Subject: Re: Assign Role based on Table Cell value
To: =?UTF-8?B?w4Yg4oCi?= <hiwire03@yahoo.com>
Cc: "pgadmin-support@lists.postgresql.org"
 <pgadmin-support@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000024a12206337f8c39"
Archived-At: 
 <https://www.postgresql.org/message-id/CANxoLDdQE9JBqWFPQDOPrMQS_57qMm7j-pqeHvCAp1jJ4Q_3sg%40mail.gmail.com>
Precedence: bulk

--00000000000024a12206337f8c39
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

pgAdmin 4 includes a Row Level Security (RLS) Policy (
https://www.pgadmin.org/docs/pgadmin4/9.2/rls_policy_dialog.html#index-0)
feature, which you can try=E2=80=94it may help resolve the issue.

On Thu, Apr 24, 2025 at 5:57=E2=80=AFAM =C3=86 =E2=80=A2 <hiwire03@yahoo.co=
m> wrote:

> I have several users accessing PostgreSQL database managed through
> pgAdmin. The database consists of a table with several columns and rows. =
I
> want to grant permission to certain users to write/edit certain certain
> rows based on the value of a certain cell i.e., if cell value =3D x than =
user
> 123 has edit rights. From what I have understood, the Grant Wizard grants
> access to the entire table. Is there anyway be more granular in granting
> access/assigning roles?
> Thanks
>

--00000000000024a12206337f8c39
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>pgAdmin 4 includes a Row Level Secu=
rity (RLS) Policy (<a href=3D"https://www.pgadmin.org/docs/pgadmin4/9.2/rls=
_policy_dialog.html#index-0">https://www.pgadmin.org/docs/pgadmin4/9.2/rls_=
policy_dialog.html#index-0</a>) feature, which you can try=E2=80=94it may h=
elp resolve the issue.</div></div><br><div class=3D"gmail_quote gmail_quote=
_container"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Apr 24, 2025 at 5=
:57=E2=80=AFAM =C3=86 =E2=80=A2 &lt;<a href=3D"mailto:hiwire03@yahoo.com">h=
iwire03@yahoo.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote"=
 style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);p=
adding-left:1ex"><div><div style=3D"font-family:&quot;Helvetica Neue&quot;,=
Helvetica,Arial,sans-serif;font-size:13px"><div dir=3D"ltr"><span>I have se=
veral users accessing PostgreSQL database managed through pgAdmin. The data=
base consists of a table with several columns and rows. I want to grant per=
mission to certain users to write/edit certain certain rows based on the va=
lue of a certain cell i.e., if cell value =3D x than user 123 has edit righ=
ts. From what I have understood, the Grant Wizard grants access to the enti=
re table. Is there anyway be more granular in granting access/assigning rol=
es?</span></div><div dir=3D"ltr"><span>Thanks</span></div></div></div></blo=
ckquote></div>

--00000000000024a12206337f8c39--