Is it possible to implement a dynamic permissions system?
I currently have defined a Role type, and I use a ‘helper’ type (Assignment) that allows users to be assigned to a role with a start date and an end date, i.e.
Role 1:n Assignment
User 1:n Assignment
I use a formula in the Assignment type to determine if it is current (start < today < end) and a formula in the Role type to filter for all related Assignments that are current. I can then have a lookup in the Role type to find all Users who are currently assigned.
This means that the Role type does have a relationship to the User type, but it is a calculated, read-only relationship, and I can’t enable the ‘Use Roles to manage access’.
Any suggestions?