-
Title
Though SP_OCT_DENIED_USERID has been configured, SharePlex still replicates DDL for non-replicating objects -
Description
Though SP_OCT_DENIED_USERID has been configured, SharePlex still replicates DDL for non-replicating objects. The parameter SP_OCT_REPLICATE_ALL_DDL is set to 1 to enable replication of supported DDL for non-replicating objects.
-
Cause
General information. -
Resolution
The parameter SP_OCT_DENIED_USERID only controls replication of DML and DDL for replicating objects. It has no bearing on the replication of DDL for non-replicating objects. So, even though the parameter is enabled for ignoring actions of a specific user, if SP_OCT_REPLICATE_ALL_DDL is set to 1, then DDL for non-replicating objects will be replicated even when such DDL are executed by that user.
To have a more granular control over DDL replication by a specific user, configure the SHAREPLEX_DDL_CONTROL table. See SharePlex Administrator Guide for details.