Solved: Re: RLS

Anonymous · ‎10-10-2022

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!

Smalfly · ‎10-10-2022

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.

Anonymous · ‎10-10-2022

@Smalfly Thank you!!

Smalfly · ‎10-10-2022

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

Smalfly · ‎10-10-2022

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.

RLS