RLS on multiple Users

[NiceDuck]

Is there a way to assign a record to multiple Users via Record Level Security?

[NiceDuck]

The quick answer is no, but there are few workarounds.

The first one is by the use of Data Grouping. 

Instead of marking the records with the ID of individual users, create a group of for your users and mark the records to which group they belongs



On this case, if we use demo_table1  on a report datapage with RLS, we will use the test_1 field from the authentication field and the test_val field from the demo_table 1

Cons of this workflow: If a user needs to access the a record that belongs to another group, then we are back on the same problem

[NiceDuck]

Another workaround is instead of using RLS, create a hidden search field on the search form.

On the data table, what we will need there is a field that contains a comma separated values of the User IDs that are allowed to see the data. 



 

Cons of this workflow,

its a big hassle on configuring who can access the records. I mean, it is easy to just concatenate additional user_Ids, but the hassle will start if you want to remove them or replace them.

Since you will have to manually do that on the comma separated values . 
 

[NiceDuck]

The last one is this, it uses list string fields.

First, ofcourse, create a list string field on the data table. Import list values from the user table and make sure to use the ID field.



Then just do the same setup mentioned on the previous response:



just this time, use the list string field instead.

Cons of this setup: everytime you have a new user, you will have to manually add their ID on the list string field used on the data table. Also, you cant use list string on triggers and such