Forum Discussion

eirika's avatar
eirika
Frequent Visitor
2 years ago
Solved

RLS security

I have 3 tables: access - this table holds userid and access_id. each user has one row for each access_id he has access to. access_id is the foreign key for the tables t1 and t2 t1 - this table ho...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    eirika 

    Great I've added some fake email addresses and used UserPrincipalName to apply the filter:
    testrls - sam.pbix

     

    You can impersonate an email by entering it into Other user and ticking the role you want to test:

     

     

SamWiseOwl's avatar
SamWiseOwl
Super User
2 years ago

Hi eirika 

Under the RLS for t2 could you add a filter to AccessId=

AccessID IN Values(access[AccessID)

Same with t1

AccessID IN Values(access[AccessID)

 

 

This should directly apply filters onto those tables based on the list of ID the person has

eirika's avatar
eirika
Frequent Visitor
2 years ago

Hi,

Thanks for your response.

Sorry to say that this didn't work. It doesn't filter out anything, so the result is the same as without the new filters.

 


 
  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    2 years ago

    Hi eirika  Can you share a sample file? It works on my test file but the stucture could be different.