Relative Content

Tag Archive for postgresqltriggerssql-insertsql-grantrow-level-security

Postgres Permissions violated by before-insert trigger function

I’ve got a table with row level permissions enabled. I’ve got an insert policy for my user, and I’ve granted permissions for them on specific columns. I added a new column to track the id of whoever inserts columns, and populate it with a BEFORE INSERT trigger.