Granular Permissions and Replication Server Configuration

You must manually create the Replication Server maintenance user IDs for user databases and RSSD on Adaptive Server.

If you enable granular permissions for Adaptive Server primary and replicate user databases that are part of a replication system, and the user ID that you use to log in to Replication Server and run either the rs_init interactive mode or rs_init resources file does not possess the sso_role, rs_init cannot automatically create the:

Maintenance user ID for the primary and replicate user databases
Maintenance and primary user IDs for the RSSD if the RSSD resides on Adaptive Server

Instead, after installing Replication Server and before you use rs_init in interactive mode or an rs_init resource file, you must manually create the user IDs for the primary and replicate user databases and RSSD, and manually grant the relevant permissions that the user IDs require for replication. With the proper permissions, you can use rs_init to successfully install RSSD on Adaptive Server and add user databases to the replication system.

Creating and Enabling the Maintenance User Role
Create the maintenance user role and grant privileges that allow the role to apply operations to the user database the maintenance user is going to manage.
Granting Required Permissions to Maintenance User Role
Grant to the maintenance user role, Adaptive Server permissions for specific operations.
Creating the Maintenance User and Assigning Roles
Create the maintenance user and assign the relevant roles to the user.

Parent topic: Granular Permissions