Adds a login to the publication’s access list.
sp_grant_publication_access [@publication =] 'publication',
[@login =] 'login' [,[@reserved =] 'reserved']
0 (success) or 1 (failure)
sp_grant_publication_access is used in snapshot, transactional, and merge replication.
This stored procedure can be called repeatedly.
Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_grant_publication_access.
sp_help_publication_access | System Stored Procedures |
sp_revoke_publication_access |