Page tree
Skip to end of metadata
Go to start of metadata

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_AdminThis role is for logins used for Admins in the CapaInstaller Console and Management Portal. It could be the administrator of the CapaInstaller installation.
CMS_SyncThis role is for logins for Services. It could be the Sync service, Front-end Service or PM Services.
CMS_User_WriterThis role is for logins used by users in the CapaInstaller Console, where the user should have permissions to write changes to the database.
CMS_User_ReaderThis 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 setup permissions on your users and login

To add a user to a role, giving the 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 RolesGo to MSDN
  • No labels