Assign Role based on Table Cell value

From: Æ • <hiwire03(at)yahoo(dot)com>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Assign Role based on Table Cell value
Date: 2025-04-24 00:26:58
Message-ID: 2094241112.614816.1745454418891@mail.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Akshay Joshi 2025-04-24 05:32:33 Re: Assign Role based on Table Cell value
Previous Message Marc Linster 2025-04-21 07:16:25 Re: Clearing the screen in the pgAdmin PSQL screen