We use DMX to archive payroll documents and so every single document in our module is restricted to an individual user account and the administrator.
When logged in as administrator I can see all documents. In permissions for the document I can see the name of the individual user who has read only access to the document.
When I log in as the individual user I cannot see some of the documents? We have tried deleting documents and reloading them and this seems to address the problem but then other documents become affected.
In addition the performance on the module for users other than the administrator has become really slow at around the same time as we started identifying problems with permissions. The only document on the page is the DMX module and for a non administrator user takes more than 2 minutes to open.
For the administrator the page opens in well under 30 seconds.
We tried adding indexes to the userroles and dmx_entries as suggested in another post on this forum but this did not seem to have any visible impact.
Should we try to rebuild the archive from scratch? or any other suggestions?