How to create different level of user profiles in SQL Server Management Studio
I am very new to SQL Server 2012 admin. Can someone please guide me? I want to create several user logins( with different privileges) so that users can access the database(s) from different machines. If I look at SQL management Studio, I see “Logins” under “Security” and again I see “Users” under “Security” under individual Databases. Do I need to create username in both places? I’d like to know how do I create username with different level of access.