Forum Discussion
Username() filtering a simple table. No RLS or TABLE EDITOR
Gente, tudo bem? Gostaria de uma maneira simples de medir com username(), filtrar uma tabela ou um visual. Não quero usar o RLS e também o recurso Editor de Tabelas. Há mais de 800 funcionário...
Read the documentation. Dynamic RLS works by having a reference table with email addresses and their permissions. That is your RLS table that then needs to control the rest of the data model.
See, I checked some dynamic RSL guidance, but see. In this step I have to enter the 800 employees' emails, for example.
And this is also dynamic. Tomorrow it could be 700/900.
It's just something so I don't have to do this that I'm looking for.
See the figure.
I am required to enter emails for RLS to work.