If you're looking to get up to speed quickly on how users, logins, roles, and permissions work in SQL Server, I'd recommend spending 40 minutes w/ the following videos (if you don't have that long, crank up the playback speed):