suser_name

Syntax

suser_name([server_user_id])

Parameters

• server_user_id – is an SAP ASE user ID.

Examples

• Example 1 – Returns the name of the current user:

  select suser_name()

  ------------------------------
  sa

• Example 2 – Returns the name of the user whose server ID is 4:

  select suser_name(4)

  ------------------------------
  margaret

Usage

See alsoTransact-SQL Users Guide .

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute suser_name.