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

See also

“SUSER_ID function [System]”

“USER_NAME function [System]”