Granular Permissions and DDL Replication

If you enable granular permissions for Adaptive Server and you use a database replication definition to replicate DDL statements, and the user who executes the DDL statement does not have the execute permission for the rs_update_last_commit stored procedure on the replicate database, the DDL statement fails with an error message such as:

Message from server: Message: 10330, State 1, Severity 14 -- 
'EXECUTE permission denied on object rs_update_lastcommit, database rdb1, owner dbo

If you enable granular permissions, set dsi_replication_ddl on for the connection to the replicate database to allow Replication Server to use the maintenance user to execute rs_update_last_commit:

alter connection to dataserver.database set dsi_replication_ddl on