X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/cdff1d7e5eadb611578090585e1e54aae41e7e66..3911cd836c4e937262d48f9b0af703a9d7d68cdd:/services/api/app/models/log.rb diff --git a/services/api/app/models/log.rb b/services/api/app/models/log.rb index 7f2d3ef13e..75e1a4e402 100644 --- a/services/api/app/models/log.rb +++ b/services/api/app/models/log.rb @@ -67,17 +67,12 @@ class Log < ArvadosModel return self end user_uuids = users_list.map { |u| u.uuid } - uuid_list = user_uuids + users_list.flat_map { |u| u.groups_i_can(:read) } - uuid_list.uniq! - permitted = "(SELECT head_uuid FROM links WHERE link_class='permission' AND tail_uuid IN (:uuids))" + joins("LEFT JOIN container_requests ON container_requests.container_uuid=logs.object_uuid"). - 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) end protected