The value of the ddl_username parameter cannot be the same as the value of the maintenance user defined in Replication Server for the replicate connection. If these names are the same, a Replication Server error results.
The value of the ddl_username parameter is sent in the LTL for all replicated DDL statements. When DDL is replicated, Replication Server connects to the replicate database using the user ID and password specified by the ddl_username and ddl_password parameters. Replication Server then issues the following command:
ALTER SESSION SET CURRENT_SCHEMA=user
Here, user is the user ID that generated the DDL operation at the primary database. The actual DDL command is then executed against the replicate database. If the user ID specified in ddl_username does not have permission to issue the ALTER SESSION SET CURRENT_SCHEMA or to execute the DDL command against the user schema, the command fails.
To replicate DDL, Replication Server must have a database-level replication
definition with replicate DDL set in the definition. See
the Replication Server Reference Manual.
