During the metabase installation, Connect CDC Director created the omnirep database and granted privileges to its owner rpuser (replication user). After the metabase install, you must prepare the database by adding rpuser as the db_owner.
- Right-click the server, then select Prepare User Database from the context menu of the server.
- Enter the individual database 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.