EnumPublicationAccesses Method

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The EnumPublicationAccesses method returns a QueryResults object that enumerates Microsoft SQL Server logins.

語法


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

備註

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

請參閱

參考

GrantPublicationAccess Method
RevokePublicationAccess Method

說明及資訊

取得 SQL Server 2005 協助