Publication Properties, Publication Access List
The Publication Access List page of the Publication Properties dialog box allows you to add and remove logins, accounts, and groups from the publication access list (PAL). The PAL is the primary mechanism for securing the Publisher. When you create a publication, replication creates a PAL for the publication. The PAL, which functions similarly to a Microsoft Windows access control list, contains a list of logins, accounts, and groups that are granted access to the publication.
When a Subscriber connects to the Publisher or Distributor and requests access to a publication, the login of the Subscriber is compared against the authentication information in the PAL. This provides additional security for the Publisher by preventing the Publisher and Distributor login from being used by a client tool to perform modifications on the Publisher directly. For more information, see Securing the Publisher.
Options
- Add
Add a new entry to the list. You can add only those login, account, or group names that are already defined at both the Publisher and Distributor. They are defined at both servers if domain accounts are used or local accounts have been created at both servers.
- Remove
Remove the selected entry from the list.
- Remove All
Remove all entries from the list.
See Also
Other Resources
How to: Create a Publication and Define Articles (SQL Server Management Studio)
How to: View and Modify Publication and Article Properties (SQL Server Management Studio)
Publishing Data and Database Objects
Replication Properties
Replication Wizards