I know that in SharePoint, we can enable item Level security and configure it so that each list item can only be viewed and edited by the person who created it (and also by anyone with Full Control permission to the list).
I was curious if this functionality could be extended so that the list item can be viewed by at least two people (excluding those with Full Control), i.e. the person who created the list item, and another person whose name would appear in a custom field on that same list item?
The idea is that someone could raise a request (list item) to swap a work shift with another nominated person. The list item would need to be viewable by the requestor and the nominated person only, and absolutely no one else should be able to see it under any circumstances.
Is this possible using a SharePoint 2013 on-premises list using out of the box features, or in worst case scenario - using SharePoint Designer 2013?
I suspect it is not, but wanted to see if anyone had to solve a similar problem in the past.