Unanswered: How can get Users authorization benefits.
I am new to MS SQL Server.
I am working on MS SQL Server Login and Users creation.
My doubt is if I am creating two users mapped with the one and same login and I am authorizing 1st user on first few tables and 2nd user with rest of the tables then how I will be benefitted of creating users where I am logging in with the log in name? If those users are loging in with login name then how the benefit of rights restriction will get?