共用方式為


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.