RevokePublicationAccess Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The RevokePublicationAccess method removes the specified login from the publication access list.
Syntax
object.RevokePublicationAccess(szLoginName)
Parts
object
Expression that evaluates to an object in the Applies To list.szLoginName
String that names a Microsoft SQL Server login existing on the Publisher.
Prototype (C/C++)
HRESULT RevokePublicationAccess(SQLDMO_LPCSTR szLoginName);
Remarks
Revoking permission from a login by using the RevokePublicationAccess method of the MergePublication or TransPublication object requires appropriate permission. The SQL Server login used for SQLServer object connection must be a member of the system-defined role db_owner in the database published, or a member of a role with greater privilege.