affects OMERO versions 5.3.3 and earlier
A user could create an OriginalFile and adjust its path such that it now points to another user's file on the underlying filesystem, then manipulate the user's data.
Security relies on the uniqueness constraint on (path, name, repo) on the originalfile table in the database. 2017-SV5 adjusts that constraint to be insensitive to certain variations in the use of "/" characters.
OMERO.server up to and including 5.3.3
For OMERO 5.2, apply the provided SQL script to prevent the update of originalfile path and name with certain variations in the use of "/" characters:
If the script fails, then it is possible that file manipulation has taken place. Please contact
email@example.com for help.
As always when applying a database upgrade, please take a database backup beforehand.
All OMERO.servers should be upgraded to at least 5.3.4.