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

Access to a publication is controlled by the publication access list (PAL). Logins and groups can be added and removed from the PAL, and information about PAL members can be viewed programmatically by using replication stored procedures.

Note

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

To view groups and logins that belong to the PAL

  1. At the Publisher on the publication database, execute sp_help_publication_access. For @publication, specify the publication name. This displays information about the groups and logins in the PAL.

To add groups and logins to the PAL

  1. At the Publisher on the publication database, execute sp_grant_publication_access. For @publication, specify the publication name; and for @login, specify the name of the login or group that is being added.

To remove groups and logins from the PAL

  1. At the Publisher on the publication database, execute sp_revoke_publication_access. For @publication, specify the publication name; and for @login, specify the name of the login or group that is being removed.

See Also

Other Resources

Securing a Replication Topology (SQL Server Management Studio)
Securing the Publisher

Help and Information

Getting SQL Server 2005 Assistance