USER_NAME function [System]

Function

Returns the user name.

Syntax

USER_NAME ( [ user-id ] )

Parameters

user-id The user identification number.

Examples

The following statement returns the value “DBA”:

SELECT USER_NAME ( 1 ) FROM iq_dummy

The following statement returns the value “SYS”:

SELECT USER_NAME ( 0 ) FROM iq_dummy

Standards and compatibility

SQL92 Vendor extension

Sybase Adaptive Server Enterprise function implemented for Sybase IQ. In Adapter Server Enterprise, USER_NAME returns the user name, not the server user name.

See also

“SUSER_NAME function [System]”

“USER_ID function [System]”