Re: Assign Role based on Table Cell value

From: Bastiaan Wakkie <bwakkie(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: Assign Role based on Table Cell value
Date: 2025-04-25 11:18:58
Message-ID: 980c6639-2dec-46c2-86e7-2d1b38ea1506@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Elizabeth Kirby 2025-04-29 14:39:45 Connecting to server over an tunnel with identity file
Previous Message Akshay Joshi 2025-04-24 05:32:33 Re: Assign Role based on Table Cell value