authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_user_property_init
Parameters
Name
Type
Mode
Definition
BEGIN PERFORM sp_reset_user_permissions(new.user_id, new.prop_id); INSERT INTO public.user_app_access(user_id, app_code, prop_id) VALUES (new.user_id, 'pms', new.prop_id) ON CONFLICT DO NOTHING; RETURN NULL; END