Differences

This shows you the differences between two versions of the page.

--- ms_sql_create_readonly_user [2021/05/07 03:13] – created ghachey
+++ ms_sql_create_readonly_user [2021/05/07 03:14] (current) – ghachey
@@ Line 1: / Line 1: @@
-MS SQL Create Readonly User
+====== MS SQL Create Readonly User ======
 Useful for giving secure access to the data warehouse to users.
@@ Line 5: / Line 5: @@
 Create a new security login user.
-{{ :sysadmin-manual:dbreadonly-1.png?nolink |}}
+{{ :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 |}}
+{{ :sysadmin-manual:dbreadonly-2.png?nolink&400 |}}
 Server role is just public.
-{{ :sysadmin-manual:dbreadonly-3.png?nolink |}}
+{{ :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 |}}
+{{ :sysadmin-manual:dbreadonly-4.png?nolink&400 |}}
 Th status should be Grant and Enabled.
-{{ :sysadmin-manual:dbreadonly-6.png?nolink |}}
+{{ :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 |}}
+{{ :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]].