Udostępnij za pośrednictwem


EnumPublicationAccesses 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 EnumPublicationAccesses method returns a QueryResults object that enumerates Microsoft SQL Server logins.

Syntax


object
.EnumPublicationAccesses( [ bReturnGranted ] )as QueryResults

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • bReturnGranted
    TRUE or FALSE.

Prototype (C/C++)

HRESULT EnumPublicationAccesses(
LPSQLDMOQUERYRESULTS* ppResults,
BOOL bReturnGranted = TRUE);

Returns

A QueryResults object that contains one result set defined by these columns.

Column Data type Description

isntgroup

integer

When 1, the value of the loginname column identifies a Microsoft group account.

isntname

integer

When 1, the value of the loginname column identifies a Windows account.

loginname

nvarchar(129)

Name of a SQL Server login

Remarks

When bReturnGrantedis TRUE, the result set enumerates those login records in the publication access list.

When bReturnGranted is FALSE (default), the result set enumerates login records not in the publication access list.

Applies To:

MergePublication Object

TransPublication Object

See Also

Reference

GrantPublicationAccess Method
RevokePublicationAccess Method

Help and Information

Getting SQL Server 2005 Assistance