GetUserName Method

SQL-DMO

SQL-DMO

GetUserName Method

The GetUserName method returns the database user used by the referenced login, when a connection using that login accesses the specified database.

Applies To
Login Object
Syntax

object.GetUserName( Database )

Parts

object

Expression that evaluates to an object in the Applies To list

Database

String that identifies an existing Microsoft® SQL Server™ 2000 database by name

Prototype (C/C++)

HRESULT GetUserName(SQLDMO_LPCSTR DatabaseName,
SQLDMO_LPBSTR pRetVal);

Note  SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

Returns

A string that identifies a database user

Remarks

The GetUserName method returns an empty string when the login specified does not have access to the database.