Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

RLS

Hi, I would like to create a role in Row Level Security where a user can see both countries, Germany and France. How do I write the expression?

 

Many thanks!

 

 

  • Hi Anonymous ,

     

    you can use:

     

    Tablename[Country] = "Germany" || Tablename[Country] = "France"

     

    where || means OR so the user will see the data if Country is Germany or France.

3 Replies

  • Smalfly's avatar
    Smalfly
    Responsive Resident

    Hi Anonymous ,

     

    you can use:

     

    Tablename[Country] = "Germany" || Tablename[Country] = "France"

     

    where || means OR so the user will see the data if Country is Germany or France.

    • Smalfly's avatar
      Smalfly
      Responsive Resident

      You're welcome, I'm glad I could help.