Useful for giving secure access to the data warehouse to users.

Create a new security login user.

Use the SQL server user password and you can default to database you are creating the read only user for.

Server role is just public.

User mapping to the database you want to give read only access. And select db_readonly role.

Th status should be Grant and Enabled.

The final step is not necessary it only shows that a database user was created also when creating the SQL user login following previous steps.

Source how to.