I have the requirement where a User can have access to multiple permissions for now we will donate those permissions as letters. On each record we can define what permission is required to access the record. If they have any one of those permissions they should be able to access that record.
Here is an example of a dataset
I need the ability to filter those rows by a user attribute which could have an array of those permissions.
For example I would define a user attribute Reps where I could defined a set of Rep Codes by user would have access to. However, it seems that a custom user attribute does not support an attribute with an array. I would like to have an array for example on the user with values: A, G which would give the access to row 1 and 3.
The only think that could technically work is groups as it supports arrays, but because of the nature our system the number of groups would be equal to the number of users. We would have to create 200,000 groups wich would not be sustainable.
