authen.public

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'
      AND (g.app_code = NEW.app_code OR g.app_code IS NULL)
    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 DISTINCT up.prop_id, up.user_id, NEW.code, NEW.id
    FROM public.user_property up
    WHERE EXISTS (
              SELECT 1
              FROM public.user_roles ur
              JOIN public.user_group g ON g.id = ur.group_id
              WHERE ur.user_id = up.user_id
                AND ur.prop_id = up.prop_id
                AND ur.active
                AND g.group_type = 'S'
                AND (g.app_code = NEW.app_code OR g.app_code IS NULL)
          )
       OR EXISTS (
              SELECT 1
              FROM public.users usr
              JOIN public.user_group g ON g.id = usr.user_group_id
              WHERE usr.id = up.user_id
                AND g.group_type = 'S'
                AND (g.app_code = NEW.app_code OR g.app_code IS NULL)
                AND NOT EXISTS (
                    SELECT 1 FROM public.user_roles ur2
                    WHERE ur2.user_id = up.user_id
                      AND ur2.prop_id = up.prop_id
                      AND ur2.active
                )
          )
    ON CONFLICT ON CONSTRAINT user_permission_pkey DO UPDATE
    SET perm_id = EXCLUDED.perm_id;

RETURN NULL;
END;

sp_tr_permission_init

Description

Parameters

Definition