Changeset 5615

Timestamp:

08/28/14 14:22:34 (10 years ago)

Author:

Menzo Windhouwer

Message:

M ISOcat-schema-views.sql

• fixed view_dc_access to not include the group owner without any rights ((s)he is already included as an user with the proper rights)

File:

• cats/ISOcat/trunk/mod-ISOcat-access-data/dbms/ISOcat-schema-views.sql (modified) (1 diff)

cats/ISOcat/trunk/mod-ISOcat-access-data/dbms/ISOcat-schema-views.sql

@@ -554 +554 @@
                           JOIN link_group_members ON link_group_members.member = view_dcs_dc.owner AND link_group_members."group" = link_dcs_access.account -- the owner of DC is a member of a group and the group has access to the DCS
                           WHERE link_group_members.status::text = 'accepted'::text -- only accepted members incl. owner play a role
-                  ) oig ON oig.dcs = view_dcs_access.dcs
+                  ) oig ON oig.dcs = view_dcs_access.dcs  AND view_dcs_access.type != 'owner' -- skip group owners, they are also included as users
   ) access
   GROUP BY access.dc, access.account, access.type;