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.
The DDL user must be a different user than the maintenance user
Setting up the DDL user in the Primary database assumes
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.
