A role has UPDATE on table A.
There's a trigger on table B which updates A.
The user can insert into B, but the trigger to update A fails:
CONTEXT: SQL statement "UPDATE A SET c = NEW.c WHERE id = NEW.id"
PL/pgSQL function schema.tg_function() line 3 at SQL statement
What additional perms are needed so the user inserting into B (which they
have permission for) can successfully update A via that trigger?
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>