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

[Wells Oliver <wells.oliver@xxxxxxxxx>]

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.oliver@xxxxxxxxx