Revoking PUBLISH permission

Use the following procedure to revoke the PUBLISH permission from a user.

Caution

Changing the publisher at a remote database or at the consolidated database can cause serious problems for any subscriptions
that the database is involved in, including the loss of information. See Changes to avoid on a running system.