Share via


GrantPublicationAccess 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 GrantPublicationAccess method adds the specified login to the publication access list.

Syntax

object.GrantPublicationAccess(szLoginName)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

  • szLoginName
    String that identifies an existing Microsoft SQL Server login by name.

Prototype (C/C++)

HRESULT GrantPublicationAccess(SQLDMO_LPCSTR szLoginName);

Remarks

Granting privilege to a login using the GrantPublicationAccess method of the MergePublication or TransPublication object requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the system-defined role db_ownerin the published database, or a role with greater privilege.