Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

Publication.RevokePublicationAccess Method

Removes the specified login from the publication access list (PAL).

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public void RevokePublicationAccess(
	string loginName
)

Parameters

loginName
Type: String
A String value that specifies the login of a user in the PAL.

ExceptionCondition
ApplicationException

If the publication does not exist on the server.

ArgumentException

If the supplied String is null, too long, or invalid.

Only members of the sysadmin fixed server role at the Publisher or the db_owner fixed database role on the publication database can call RevokePublicationAccess.

Calling RevokePublicationAccess is equivalent to executing sp_revoke_publication_access (Transact-SQL).

Community Additions

Show:
© 2015 Microsoft