ReadOnly User

CREATE LOGIN reader WITH password='******';
GO
USE Database;
GO
CREATE USER reader FOR LOGIN reader;
GO
ALTER ROLE db_datareader ADD MEMBER reader;
GO