To grant or revoke access to a publication

To grant or revoke access to a publication

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 the Publisher and the Distributor. If the pull subscription login is not in the publication access list, an error appears at the Subscriber.