Query SQL Server Create User And Grant Select to single database

 CREATE LOGIN [username] WITH PASSWORD = 'password', DEFAULT_DATABASE = [database_name]

GO


USE database_name;

CREATE USER username FOR LOGIN username;

GO 


GRANT SELECT TO username

GO