User creation in SQL server

 USE [master]

GO

CREATE LOGIN [viewer] WITH PASSWORD=N'Re@d', CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO

USE [DB]

GO

CREATE USER [viewer] FOR LOGIN [viewer]

GO

USE [DB]

GO

ALTER ROLE [db_datareader] ADD MEMBER [viewer]

GO