Sample User (user_id:28358) with profile “Sales” (group_id:473) can’t see Employees: Principal routine to check permissions create function acs_permission__permission_p(int4,int4,varchar) returns bool as ‘ declare permission_p__object_id alias for $1; permission_p__party_id alias for $2; permission_p__privilege alias for $3; exists_p boolean; begin return exists (select 1 from acs_permissions p, party_approved_member_map m, acs_object_context_index c, acs_privilege_descendant_map h where p.object_id = c.ancestor_id [...]