authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_permission_init
Parameters
Name
Type
Mode
Definition
BEGIN INSERT INTO public.group_permission(group_id, code, perm_id) SELECT g.id, NEW.code, NEW.id FROM public.user_group g WHERE g.group_type = 'S' ON CONFLICT ON CONSTRAINT group_permission_pkey DO UPDATE SET perm_id = EXCLUDED.perm_id; INSERT INTO public.user_permission(prop_id, user_id, code, perm_id) SELECT u.prop_id, u.user_id, NEW.code, NEW.id FROM public.user_property u JOIN public.users usr ON usr.id = u.user_id JOIN public.user_group g ON usr.user_group_id = g.id WHERE g.group_type = 'S' ON CONFLICT ON CONSTRAINT user_permission_pkey DO UPDATE SET perm_id = EXCLUDED.perm_id; RETURN NULL; END