public inbox for [email protected]  

help / color / mirror / Atom feed

Assign Role based on Table Cell value
3+ messages / 3 participants
[nested] [flat]

* Assign Role based on Table Cell value
@ 2025-04-24 00:26  Æ • <[email protected]>
  0 siblings, 2 replies; 3+ messages in thread

From: Æ • @ 2025-04-24 00:26 UTC (permalink / raw)
  To: [email protected] <[email protected]>

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Assign Role based on Table Cell value
@ 2025-04-24 05:32  Akshay Joshi <[email protected]>
  parent: Æ • <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Akshay Joshi @ 2025-04-24 05:32 UTC (permalink / raw)
  To: Æ • <[email protected]>; +Cc: [email protected] <[email protected]>

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 Æ • <[email protected]> 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
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Assign Role based on Table Cell value
@ 2025-04-25 11:18  Bastiaan Wakkie <[email protected]>
  parent: Æ • <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Bastiaan Wakkie @ 2025-04-25 11:18 UTC (permalink / raw)
  To: [email protected]

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2025-04-25 11:18 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-04-24 00:26 Assign Role based on Table Cell value Æ • <[email protected]>
2025-04-24 05:32 ` Akshay Joshi <[email protected]>
2025-04-25 11:18 ` Bastiaan Wakkie <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox