- where("logs.object_uuid IN #{permitted} OR "+
- "container_requests.uuid IN (:uuids) OR "+
- "container_requests.owner_uuid IN (:uuids) OR "+
- "logs.object_uuid IN (:uuids) OR "+
- "logs.owner_uuid IN (:uuids) OR "+
- "logs.object_owner_uuid IN (:uuids)",
- uuids: uuid_list)
+ where("EXISTS(SELECT target_uuid FROM #{PERMISSION_VIEW} "+
+ "WHERE user_uuid IN (:user_uuids) AND perm_level >= 1 AND "+
+ "target_uuid IN (container_requests.uuid, container_requests.owner_uuid, logs.object_uuid, logs.owner_uuid, logs.object_owner_uuid))",
+ user_uuids: user_uuids)