Granular Permissions

Configure your replication system to ensure replication support for Adaptive Server granular permissions.

Adaptive Server granular permissions enable you to grant system privileges that allow you to construct site-specific roles with privileges to match your requirements, and restrict system administrators and database owners from accessing user data. See Using Granular Permissions in the Adaptive Server Enterprise Security Administration Guide.

Replication Server supports the replication of the Adaptive Server sp_restore_system_role system procedure which you can use to restore a system-defined role to its default privilege condition after applying granular permissions to the role.

• Granular Permissions and Replication Server Configuration
  You must manually create the Replication Server maintenance user IDs for user databases and RSSD on Adaptive Server.
• Granular Permissions and Adding a User Database
  If you enable granular permissions, and then manually configure the maintenance user permissions, you see an error message when you use the rs_init interactive mode to add a database to the replication system.
• Granular Permissions and User Database Upgrade
  If you use rs_init to upgrade Adaptive Server user databases, you see an error message.
• Granular Permissions and Master Database Replication
  Remove the maintenance user ID alias relationship to the dbo master database owner before you add the master database as a replicate database.
• Granular Permissions and DDL Replication
  Enable dsi_replication_ddl to replicate DDL statements.