====== MS SQL Create Readonly User ======

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

Create a new security login user.

{{ :sysadmin-manual:dbreadonly-1.png?nolink&400 |}}

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

{{ :sysadmin-manual:dbreadonly-2.png?nolink&400 |}}

Server role is just public.

{{ :sysadmin-manual:dbreadonly-3.png?nolink&400 |}}

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

{{ :sysadmin-manual:dbreadonly-4.png?nolink&400 |}}

Th status should be Grant and Enabled.

{{ :sysadmin-manual:dbreadonly-6.png?nolink&400 |}}

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.

{{ :sysadmin-manual:dbreadonly-8.png?nolink&400 |}}

Source [[https://www.itsupportguides.com/knowledge-base/server-side-tips/sql-management-studio-how-to-create-read-only-users/|how to]].