Content-Type: multipart/alternative;
 boundary="------------xUbPfFjYOd000TNfRnHtbnfn"
Message-ID: <980c6639-2dec-46c2-86e7-2d1b38ea1506@gmail.com>
Date: Fri, 25 Apr 2025 13:18:58 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Assign Role based on Table Cell value
To: pgadmin-support@lists.postgresql.org
References: <2094241112.614816.1745454418891.ref@mail.yahoo.com>
 <2094241112.614816.1745454418891@mail.yahoo.com>
Content-Language: en-US, nl
From: Bastiaan Wakkie <bwakkie@gmail.com>
In-Reply-To: <2094241112.614816.1745454418891@mail.yahoo.com>
Archived-At: 
 <https://www.postgresql.org/message-id/980c6639-2dec-46c2-86e7-2d1b38ea1506%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------xUbPfFjYOd000TNfRnHtbnfn
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

There is row-level security from PostgreSQL 9.5 onwards, see if that 
fits your needs.

On 4/24/25 02:26, Æ • 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 = 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
--------------xUbPfFjYOd000TNfRnHtbnfn
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html data-lt-installed="true">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body style="padding-bottom: 1px;">
    <p><font face="monospace">There is row-level security from
        PostgreSQL 9.5 onwards, see if that fits your needs.</font></p>
    <div class="moz-cite-prefix">On 4/24/25 02:26, Æ • wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:2094241112.614816.1745454418891@mail.yahoo.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div class="yahoo-style-wrap"
style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;">
        <div dir="ltr" data-setdir="false"><span>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 = 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?</span></div>
        <div dir="ltr" data-setdir="false"><span>Thanks</span></div>
      </div>
    </blockquote>
  </body>
  <lt-container></lt-container>
</html>

--------------xUbPfFjYOd000TNfRnHtbnfn--