Skip to main content
SUBMITTED

Definition of RLS in tabular models

Related products:TimeXtender Data Integration
  • December 28, 2023
  • 0 replies
  • 24 views

rvgfox
Problem Solver
Forum|alt.badge.img+4

When we create a RLS Setup using dynamic like this:

 

 

TX creates an internal table like:  ..Companies_CompanyName_SecurityTable

This table it’s filled in the deploy&run proccess in TX.

The first problem is that if we are using an external process to refresh the data, in this case the internal table is not updated, but we could avoid this by using a script action to populate that table.

My suggestion is to not create the security table, create a security view instead.

With this approach the data will be up to date.