SQL Server: Logins and Users

A Login is an identity used to connect to a SQL Server instance. A User allows you to log into a SQL Server database and is mapped to a Login. So you will need to first create a Login, before you can create a User in SQL Server.

We've divided Logins and Users into the following topics:

Logins

• CREATE LOGIN statement
• ALTER LOGIN statement
• DROP LOGIN statement
• Find Logins in SQL Server
• Change Password in SQL Server

Users

• CREATE USER statement
• DROP USER statement
• Find Users in SQL Server