Synchronization Server Help


Changing SQL privileges for a replication source

After you add a replication source to the subscription, you can change only the SQL access privileges defined for the source.

These steps are part of the larger task of editing a DataPropagator subscription. When you complete the steps for changing SQL privileges for a replication source, return to editing a DataPropagator subscription.


Figure dsyh016 not displayed.

To change the SQL privileges:

  1. From the Identification page of the Edit DataPropagator Subscription notebook, click Define subscription to open the Define Replication Subscription window.

  2. Select the replication source whose SQL privileges you want to change. The last three columns shown refer to the privileges defined for the replication source.

  3. Optional: Clear the check box for any privilege that you no longer want to allow.

  4. Click OK to close the Define Replication Subscription window.


Figure dsyh016 not displayed.

Related information

See the DB2 Universal Database Administration Guide: Design and Implementation for information about SQL privileges.

[Return to main task]


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]