SQL Server - Login

About

A login can:

• join a role
• be authorized to use a database, see Create a Database User.
• be granted permission

The database user is the identity of the login when it is connected to a database. The database user can use the same name as the login, but that is not required.

Articles Related

Management

Create

SQL

Create Statement: Create a login

• Azure SQL

CREATE LOGIN loginName WITH
		PASSWORD = 'pwd';

• SQL Server

CREATE LOGIN loginName WITH
		PASSWORD = 'pwd',
		DEFAULT_DATABASE = DefaultDatabase;

Built-in Procedure

• With the the sp-addlogin function. Example: creates a SQL Server login for the user userName, with a password of pwd and a default database of defaultDatabaseName

EXEC sp_addlogin 'userName', 'pwd', 'defaultDatabaseName'; 
GO  

Drop

• sp-droplogin

Password

ALTER LOGIN login_name WITH PASSWORD = 'pwd'

List

• SQL Azure

SELECT * from master.sys.sql_logins;