Freigeben über


EnumUsers Method

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The EnumUsers method returns a QueryResults object that enumerates the users defined in a Microsoft SQL Server database and their role participation.

Syntax

object
.EnumUsers( [ UserName ] )as QueryResults

Parts

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

  • UserName
    Optional. String that specifies a database user or role by name. When specified, directs content and membership of the returned result set.

Prototype (C/C++)

HRESULT EnumUsers(
LPSQLDMOQUERYRESULTS* ppResults,
LPCOLESTR UserName = NULL);

Returns

When UserName is not specified, or specifies a database user by name, the EnumUsers method returns a QueryResults object that contains one result set defined by these columns.

Column

Data type

Description

DefDBName

nvarchar(13)

Database used by default when a connection is made using the listed login.

GroupName

nvarchar(17)

Database role. One row is returned for each role of which the user is a member.

LoginName

nvarchar(5)

Login name.

SID

varbinary(91)

System-generated login account.

UserID

char(14)

System-generated database user identifier.

UserName

nvarchar(11)

Database username.

When UserName specifies a database role by name, the EnumUsers method returns a QueryResults object that contains one result set defined by these columns.

Column

Data type

Description

Group_id

smallint

System-generated role identifier.

Group_name

nvarchar(26)

Name of the database role.

Userid

smallint

System-generated database user identifier.

Users_in_group

nvarchar(26)

Database username.

Applies To: