Skip to content

Instantly share code, notes, and snippets.

@cazzer

cazzer/thing-permission-rls-trigger.sql

Created December 6, 2018 21:25
Show Gist options
  • Save cazzer/d8f9409765b960d81b8fcb00bfbc2244 to your computer and use it in GitHub Desktop.
Save cazzer/d8f9409765b960d81b8fcb00bfbc2244 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
thing-permission-rls-trigger.sql
create or replace function insert_permission()
returns trigger
as $$
begin
insert into permissions (item_id, user_or_group_id, role) values (
new.id,
current_setting('user_id')::uuid[]
);
return new;
end
$$ language plpgsql;
create trigger insert_permission_trigger
after insert
on things
for each row
execute procedure insert_permission();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment