Share via


How to: Manage Logins in the Publication Access List (SQL Server Management Studio)

You use the publication access list (PAL) on the Publication Access List page of the Publication Properties - <Publication> dialog box to manage logins. For more information about how to access this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio).

Note

You must associate the SQL Server login with a database user in the publication database before adding the login to the PAL.

To manage logins in the PAL

  1. On the Publication Access List page of the Publication Properties - <Publication> dialog box, use the Add, Remove, and Remove All buttons to add and remove logins and groups from the PAL. Do not remove distributor_admin from the PAL. This account is used by replication.

    Note

    If a remote Distributor is used, accounts in the PAL must be available at both the Publisher and the Distributor. The account must be either a domain account or a local account that is defined at both servers. The passwords that are associated with both logins must be the same.

  2. Click OK.

See Also

Concepts

Replication Agent Security Model
Replication Security Best Practices
Securing the Publisher

Other Resources

How to: Manage Logins in the Publication Access List (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance