Introduction

This document will explain the CapaInstaller SQL Database roles CMS_Admin, CMS_Sync, CMS_User_Writer, and CMS_User_Reader. These SQL Database roles are created from the Setup Wizard and are created to make it easy to give a user or computer login the proper permissions to elements in the SQL database.

Below is each of the server CapaInstaller SQL Database roles explained.

Element	Description
CMS_Admin	This role is for logins used for Admins in the CapaInstaller Console and Management Portal. It could be the administrator of the CapaInstaller installation.
CMS_Sync	This role is for logins for Services. It could be the Sync service, Front-end Service, or PM Services.
CMS_User_Writer	This role is for logins used by users in the CapaInstaller Console, where the user should have permission to write changes to the database.
CMS_User_Reader	This role is for logins used by users in the CapaInstaller Console, where the user should only have permission to read from the database.

These SQL Database roles cannot be used as the only SQL Security on the SQL Server. You still need to set up permissions on your users and login

To add a user to a role, giving permission from the role to the user, you can use the following SQL query. ALTER ROLE [Role name] ADD MEMBER [username].

If you want to...	You can...
Learn about needed permissions to run Setup Wizard	Permissions needed for Setup Wizard.
Read more about SQL Roles	Go to MSDN

Browser not supported