This article assumes that a login already exists in SQL Server. The database user can use the same name as the login, but that isn't required. The database user is the identity of the login when it's connected to a database. For this situation, you'll create a SQL user with login. First ask yourself, does the person or group that needs to access the database have a login? Logins in the master database are common for the people who manage the SQL Server and for people who need to access many or all of the database on the instance of SQL Server. If you're new to SQL Server, it can be difficult to determine what type of user you want to create. Login or user that is not mapped to a login The following graphic shows the six options in the green box, and indicates what they represent. Management Studio presents six options when creating a database user. You can create a database user by using SQL Server Management Studio or by using Transact-SQL. All varieties of SQL Server support database users, but not necessarily all types of users. The complete list is provided in the article CREATE USER (Transact-SQL). This article describes how to create the most common types of database users. Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
