Forum Discussion

jdusek92's avatar
jdusek92
Advocate III
7 years ago

Row level security and relationship

Hello, I have this data model: relationship model:   I want to use Row Level security via UserPrincipalName() expression. I have set up a role for table Employees: [UserPrincipalNam...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

jdusek92  you added 4 seperate tables and viewing them seperately. You dont visualize data like that right.

   Just add columns from all 4 tables into one table(visual) and see.....

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI,

 

   I have the same issue. Did you get any solution on this

  • jdusek92's avatar
    jdusek92
    Advocate III
    7 years ago

    To be sure, I include a UserPrincipalName column in each table and set up a role filtering for each table. Also I eliminate the tables that cannot be enriched with UPN column (like Job Catalog)  - data from such tables must be therefore merged+expanded to main datatables. Otherwise I cannot be sure that unwanted information will be hidden.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for your quick reply. But when we have a lookup tables it will be difficult to bring the UserName or UserPrincipal to lookup tables. I think I have a different issue, so I have created another thread here