How to grant or revoke access to a publication (Enterprise Manager)

To grant or revoke access to a publication

1. Expand a server group; then click the Publisher name.
2. On the Tools menu, point to Replication, and then click Create and Manage Publications.
3. Expand the database; then click the publication.
4. Click Properties & Subscriptions.
5. Click the Publication Access List tab.
6. Add or remove the login to access the publication.

Note If a remote Distributor is used, the new logins must exist in the publication access lists at both the Publisher and at the Distributor. If the pull subscription login is not in the publication access list, an error appears at the Subscriber.

See Also

Publication Access Lists