User has role, role has UPDATE, user can't update, cannot figure this out.

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: User has role, role has UPDATE, user can't update, cannot figure this out.
Date: 2021-03-05 21:41:20
Message-ID: CAOC+FBVPf2AHtFasggtLDqdXBX4cF44VShJaacRhp_UY0MnK0Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

It seems very straight forward, but I have a user belongs to the role
analyst, and the role analyst has the permission to UPDATE, e.g..

GRANT REFERENCES, UPDATE ON TABLE myschema.mytable TO analyst;

But the user gets a permission denied error on the table for a simple
UPDATE query. I can't figure it out: no trigger functions. A few FKs, but
nothing complex. Is there a way to figure out why this user is being denied
permission?

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Frost 2021-03-05 22:08:42 Re: User has role, role has UPDATE, user can't update, cannot figure this out.
Previous Message Wells Oliver 2021-03-05 20:59:51 Access denied on trigger UPDATE even with UPDATE perms