Creating the Database Roles in SQL Server - Installation - Foundation 23.2 - Foundation 23.2 - Ready - Content Composer - external

Content Composer Installation
Platform
Content Composer
Product
Installation
Release
Foundation 23.2
License

To improve security, Content Composer provides both read-only and full-access roles for the repository, MWS and Odin databases.

To create the database roles, complete the following steps:

  1. From the %Composerdir%admin\MS-SQL directory, open the MSSql_CreateRole.sql script.
  2. Follow the instructions provided at the top of the script.

    In the Specify Values for Template Parameters dialog box, specify the parameters for the Repository roles.

    The script creates the following roles.

    • composer_full: Provides full access.

    • composer_readonly: Provides read-only access.

  3. Repeat the previous steps for both the MWS and the Odin roles.