Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Adrian, Nov 21, 2017
- CREATE OR REPLACE FUNCTION f_authorize_user_role_policy_salesman(bigint, bigint, bigint, bigint)
- RETURNS integer AS
- $BODY$
- DECLARE
- pTenantId alias for $1;
- pUserId alias for $2;
- pRoleId alias for $3;
- pSalesmanId alias for $4;
- vResult integer;
- vSalesmanId bigint;
- vUserRoleId bigint;
- BEGIN
- vResult := 1;
- SELECT C.user_role_id, C.salesman_id INTO vUserRoleId, vSalesmanId
- FROM t_user A, t_user_role B, m_policy_salesman C
- WHERE A.tenant_id = pTenantId AND
- A.user_id = pUserId AND
- A.user_id = B.user_id AND
- B.role_id = pRoleId AND
- B.user_role_id = C.user_role_id AND
- C.salesman_id = pSalesmanId;
- IF NOT FOUND THEN
- vResult := 0;
- END IF;
- return vResult;
- END;
- $BODY$
- LANGUAGE plpgsql VOLATILE
- COST 100;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement