This documentation is archived and is not being maintained.

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.

ms147297.note(en-US,SQL.90).gifNote:
You must associate the SQL Server login with a database user in the publication database before you add the login 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.

  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.

  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.

Show: