GetUserName Method

  • Article

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

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 database by name.

Prototype (C/C++)

HRESULT GetUserName(SQLDMO_LPCSTR DatabaseName,
SQLDMO_LPBSTR pRetVal);

Note

SQL Distributed Management Objects (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.

Applies To:

Login Object