grants gives - Search results

Mailing lists  >>  pgsql-sql  >>  Thread

2020-04-05 15:46:41 | Re: How do CHECK Constraint Function privileges work? (Ruwan Fernando)

grants on functions created from that point onwards from the "PUBLIC" user role which all other roles inherit. And now started my confusion. After introducing this line early in my deployment script, the CHECK constraint

Mailing lists  >>  pgsql-sql  >>  Thread

2020-04-05 08:22:03 | How do CHECK Constraint Function privileges work? (Ruwan Fernando)

grant_test_role"; INSERT INTO app_public.test_tab (id, name) VALUES (1, 'Very Long Name'); COMMIT; My expectation was the INSERT would give