Use the Prepare User Database dialog to prepare your database for replication. This will grant access rights to the replication user to access the database for modeling and replication.
-
Right-click the server, then select Prepare User Database from the context menu of the server.
-
Enter the individual user database or schema name in the Database/Schema Name dialog.
-
Click OK.
-
Enter the DBMS Administrator userid and password in the User ID and Password dialog.
-
Click OK.
A summary of the steps that Connect CDC Director takes to prepare the database displays.
-
Click OK.
You see a screen with the commands executing and then a message that the process is complete.
-
Click OK.