Every implementation of row-level security both in Microsoft or blogs from users discusses a need to create user Example:
CREATE USER Manager WITHOUT LOGIN;
CREATEUSER Sales1 WITHOUT LOGIN;
CREATEUSER Sales2 WITHOUT LOGIN;
Can anyone highlight issues that they have faced with these physical users? What if you exhaust the limit for physical users (I think it is Server_prinicipal_id whose limit is int), what if your application supports millions of users whose data needs to be restricted based on what they can see. Is creating physical user for every logical user not an overhead?