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.
yes, I will use USERPRINCIPALNAME().
I wouldn't want to enter users into the security configuration on the service. there are 800 employees.
I already tested and managed to get the nickname through the measurement, but I couldn't put it in a data segmenter, for example.
I'm a newbie and I believe there must be a maneuver for this dynamic rls.