EnumUsers Method (SQL-DMO)

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

Applies To

Database Object

Syntax

object.EnumUsers( [ UserName ] ) as QueryResults

Part Description
object Expression that evaluates to an object in the Applies To list.
UserName Optional. String specifying a database user or role by name. When specified, directs content and membership of the returned result set.

Returns

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

Column Data type Description
UserName nvarchar(29) Database username.
GroupName nvarchar(33) Database role. One row is returned for each role of which the user is a member.
LoginName nvarchar(45) Login name.
DefDBName nvarchar(13) Database used by default when a connection is made using the listed login.
UserID char(14) System-generated database user identifier.
SUserID char(16) System-generated login identifier.

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

Column Data type Description
Group_name nvarchar(26) Name of the database role
Group_id smallint System-generated role identifier
Users_in_group nvarchar(26) Database username
Userid smallint System-generated database user identifier

Prototype (C/C++)

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

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.