=====ReadOnly User=====
<code>
CREATE LOGIN reader WITH password='******';
GO
USE Database;
GO
CREATE USER reader FOR LOGIN reader;
GO
ALTER ROLE db_datareader ADD MEMBER reader;
GO
</code>