3.6 - Known Issues

IMAGKSL-5533

When upgrading from 3.6.0-funcrel, the “admin” user may lose access to “imaging-viewer” for applications created by other users. A SQL workaround is available which should be run against the control_panel schema:

SET search_path = control_panel;
INSERT INTO profile_assigned_user (profile_guid, user_guid)
SELECT p.guid, u.guid
FROM   profile p, assigned_user u
WHERE  p.name = 'admin_profile' AND u.name = 'admin'
AND NOT EXISTS (
    SELECT 1
    FROM   profile_assigned_user pau
    WHERE  pau.profile_guid = p.guid
        AND  pau.user_guid   = u.guid
  );