Export (0) Print
Expand All

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.

NoteNote

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

  • 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

  • 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

  • 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft