What is the parameter SP_OCT_REPLICATE_GRANT? (4297167)

The parameter SP_OCT_REPLICATE_GRANT allows the GRANTs on tables in replication to be replicated across to the target table. The parameter only replicates the object level privileges. Normally it is unset (meaning set at 0) so grants executed on source table are not replicated to the target table. If wishing to replicate such grants, the parameter need to be set to 1. One noteworthy point is; it is quite possible that some grants are desirable on source tables whereas the same grants may not be desirable on the target tables. Hence the parameter need to be enabled after taken into account such considerations. There is no concept of allowing grants to be replicated selectively by the type of GRANTs or the type of objects (name, object type, etc). It is either all or none. The parameter does not allow replication of a system privilege as their scope can cover a wide range of objects and is not confined to a specific object.  

Before the advent of the parameter SP_OCT_REPLICATE_GRANT, SharePlex did allow replication of grants, roles, etc via replication of DDL on non-replicated objects by configuring the parameter SP_OCT_REPLICATE_ALL_DDL to 1. The latter still holds and in fact both these features can co-exist as their scope covers different objects which are mutually exclusive.

SharePlex do replicate DDLs relating to system level privileges as below:

CREATE, ALTER, DROP roles as well as GRANT and REVOKE roles can only be replicated if SP_OCT_REPLICATE_ALL_DDL is set to 1 which would require additional considerations like source and target being identical in many respect. The setting of parameter SP_OCT_REPLICATE_GRANT has no bearing on the replication of these DDLs which are related to roles.

Likewise GRANT and REVOKE of privileges for users can only be replicated if SP_OCT_REPLICATE_ALL_DDL is set to 1 which would require additional considerations like source and target being identical in many respect. The setting of parameter SP_OCT_REPLICATE_GRANT has no bearing on the replication of these DDLs which are related to GRANT and REVOKE of privileges for users.

Here is the description of the parameter from SharePlex Reference Guide.

SP_OCT_REPLICATE_GRANT

This parameter controls whether SharePlex replicates GRANT commands that are issued for tables that are listed in the configuration file.

Default: 0 (disabled)

Range of valid values: 0 or 1