If different security mechanisms are used at the primary and replicate databases and Adaptive Server user names cannot be guaranteed unique at these sites, a potential security breach exists for request stored procedures.
If this scenario exists on your system, you can make sure that security is maintained by turning “off” the dsi_exec_proc parameter for the connection with the primary database. Executing alter connection and turning dsi_exec_proc “off” disables Replication Server’s request-stored-procedures feature.
Here is the syntax:
alter connection to data_server.database set dsi_exec_request_sproc 'off'
