authen.public

Parameters

Name	Type	Mode
v_group_id	integer	IN
v_prop_id	integer	IN
v_codes	bpchar[]	IN
v_grant_all	boolean	IN (DEFAULT false)

Definition

DECLARE
    v_is_standard boolean;
    v_app text;
BEGIN
    SELECT (prop_id IS NULL), COALESCE(app_code, 'pms') INTO v_is_standard, v_app
    FROM public.user_group WHERE id = v_group_id;

IF v_is_standard THEN
        INSERT INTO public.group_permission_override(group_id, prop_id, code, perm_id, action_type)
        SELECT v_group_id, v_prop_id, p.code, p.id, 'allow'
        FROM public.permission p
        WHERE (v_grant_all AND p.app_code = v_app) OR p.code = ANY(v_codes)
        ON CONFLICT ON CONSTRAINT group_permission_override_pkey DO UPDATE
        SET perm_id = EXCLUDED.perm_id, action_type = 'allow', updated_at = now();
    ELSE
        INSERT INTO public.group_permission(group_id, code, perm_id)
        SELECT v_group_id, p.code, p.id
        FROM public.permission p
        WHERE (v_grant_all AND p.app_code = v_app) OR p.code = ANY(v_codes)
        ON CONFLICT ON CONSTRAINT group_permission_pkey DO UPDATE
        SET perm_id = EXCLUDED.perm_id;
    END IF;

PERFORM public.sp_reset_user_permissions(ur.user_id, ur.prop_id)
    FROM public.user_roles ur
    WHERE ur.group_id = v_group_id AND ur.prop_id = v_prop_id AND ur.active;
END

fn_role_grant_permissions

Parameters

Definition