Can you share your opinion on the best practice for Dynamically changing item permissions?
For example, given this scenario:
- Item Creator can create an initial item.
- After item creator creates, the item becomes read-only for him. Other users can create, but they can only see their own entries (Created by).
- At any point in time, other users can be given Read access (or any other access) by an Administrator to a specific item.
- The item is then given edit permission to a Reviewer and Approver. Reviewers can only edit, and Approvers can only approve.
- After the item has been reviewed, the item becomes read-only to everyone.
I read that there is only a specific number of unique permissions for a List / Library before performance issues start to set in. Given the requirements above, it looks like item-level permission is unavoidable.
Do you have certain ideas how best to go with this?