Share via


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.