How to grant or revoke access to a publication (Transact-SQL)
To grant access to a publication
Execute
sp_grant_publication_access
.
To revoke access to a publication
Execute
sp_revoke_publication_access
.
See Also
sp_grant_publication_access
sp_revoke_publication_access
(c) 1988-98 Microsoft Corporation. All Rights Reserved.