oracle8.1.6 select c.constraint_id, c.constraint_name from rel_constraints c application_group_segments s1, application_group_segments s2 where s1.segment_id = c.rel_segment and s1.package_id = :package_id and s2.segment_id = c.required_rel_segment and s2.package_id = :package_id and exists (select 1 from acs_object_party_privilege_map perm where perm.object_id = c.constraint_id and perm.party_id = :user_id and perm.privilege = 'read') order by lower(c.constraint_name)