SUSER_NAME function [System]

Function

Returns the user name.

Syntax

SUSER_NAME ( [ user-id ] )

Parameters

user-id The user identification number.

Examples

The following statement returns the value DBA:

SELECT SUSER_NAME ( 1 ) FROM iq_dummy

The following statement returns the value SYS:

SELECT SUSER_NAME ( 0 ) FROM iq_dummy

Standards and compatibility

SQL Vendor extension to ISO/ANSI SQL grammar.

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

See also

“SUSER_ID function [System]”

“USER_NAME function [System]”