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>