Was a bit quick here, found out that the SUSER_NAME() of the query is of course the connection that was setup.
So the User/Password defined here:
Once I added that same user to the RLS logic I get the correct result.
Was a bit quick here, found out that the SUSER_NAME() of the query is of course the connection that was setup.
So the User/Password defined here:
Once I added that same user to the RLS logic I get the correct result.