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...
What you are doing is basically dynamic RLS. Note that USERPRINCIPALNAME() is preferred. USERNAME is inconsistent between desktop and service.
I'm going to delve deeper into RLS.
But in the service, don't I have to insert the users that are in the table?
That would be the difficulty.
If maintenance on the service is not necessary, the problem would be solved with the internal table.