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