To replicate DDL commands for Oracle and Microsoft SQL Server, a unique user must be designated that is granted privileges to execute all replicated DDL commands at the Standby database.
This user must be different than
the Maintenance User previously created.
To set up the DDL user in the primary database
Add the DDL login to the primary data server.
Grant appropriate permissions to the DDL User login to execute any DDL command to be replicated.
Setting up the DDL user in the primary database assumes
that snapshot replication will copy this user to the standby database
along with the data. If you are using a different materialization
technique, the DDL user may need to be added directly to the standby
database. Regardless of materialization technique, the DDL user
must exist and have the appropriate permissions at the standby database
after materialization occurs.
