Can I have access to some other users records?
I wonder if it is possible to let users access specific records of other users.
Here is a description of the case:
I have created a section that contains data on patients who have an operation in a hospital. Each surgeon logs in to the CMSB with their username/password and inserts data regarding their patients who had an operation. Suppose that Surgeon A logs in to the CMSB with his/her details and inserts the data of Patient X. As Surgeon A has Author privileges for this section, he/she is the only user who can view and edit the details of Patient X. One of the fields of the section, lets the user choose from a drop-down menu the name of another surgeon (Surgeon B) who has assisted in the operation.
My question is whether it is possible to let Surgeon B have access (with view and edit privileges) for Patient X, as does Surgeon A.
It's possible if you make both the Surgeons editor access. They'll be able to see everything in a section, though, but any edits they make would update the "Last Updated by [Username]" field so there's some tracking.
Other options would be to create a custom plugin to override how the access controls work in the CMS, or to make some custom front-end pages where patients/doctors can login and access things.
Hope that helps, let me know any questions.