| From: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
|---|---|
| To: | Æ • <hiwire03(at)yahoo(dot)com> |
| Cc: | "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Assign Role based on Table Cell value |
| Date: | 2025-04-24 05:32:33 |
| Message-ID: | CANxoLDdQE9JBqWFPQDOPrMQS_57qMm7j-pqeHvCAp1jJ4Q_3sg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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—it may help resolve the issue.
On Thu, Apr 24, 2025 at 5:57 AM Æ • <hiwire03(at)yahoo(dot)com> 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bastiaan Wakkie | 2025-04-25 11:18:58 | Re: Assign Role based on Table Cell value |
| Previous Message | Æ • | 2025-04-24 00:26:58 | Assign Role based on Table Cell value |