Creates a new SQL Server login and then maps that login to a new database user : LOGIN « System « SQL Server / T-SQL

1. SQL Server / T-SQL
2. System
3. LOGIN

Creates a new SQL Server login and then maps that login to a new database user

 


USE Master
GO
CREATE LOGIN Paul WITH Password = 'P@ssword1'
GO
USE AdventureWorks
GO

CREATE USER Paul FOR Login Paul
SQL Server 2005 Windows login.

 

Related examples in the same category