USE [master]
GO
CREATE LOGIN [Pintos]
WITH PASSWORD=N’password123′ –password does not meet complexity (use upper ‘P’)
MUST_CHANGE, DEFAULT_DATABASE=[master],
CHECK_EXPIRATION=ON,
CHECK_POLICY=ON
GO
— Create a SQL Login
USE [AdventureWorks2012]
GO
CREATE USER [pintos] FOR LOGIN [Pintos]
GO
— Add SQL Login to database Role (db_datareader)
USE [AdventureWorks2012]
GO
ALTER ROLE [db_datareader]
ADD MEMBER [Pintos]
GO