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.