Jump to content
  • 0

RLS on multiple Users



3 answers to this question

Recommended Posts

  • 0

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

Link to comment
Share on other sites

  • 0

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 . 

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...