Return
-
Title
Minimum SQL permissions -
Description
As per documentation, any account used for SQL access must be configured (in SQL) with "sysadmin" and "dbcreator" permissions. Once CMN has been installed, and its SQL databases have been set, there might be a requirement to set minimum permissions to access SQL.
-
Cause
Requirement by customer to set minimum permissions to access CMN databases. -
Resolution
Once CMN has been installed and databases created, you can remove the DBCreator and SysAdmin roles and just leave behind the db_owner role for minimum access to SQL . -
Additional Information
Currently, there is no supported method of creating the "Config_Db" and "Exec_Db" databases manually. The CMN databases will need to be created by the clicking the "Set Configuration" button on the SQL Settings screen in the Coexistence Management Console.