SUSER_ID function [System]

Function

Returns an integer user identification number.

Syntax

SUSER_ID ( [user-name ] )

Parameters

user-name The user name.

Examples

The following statement returns the user identification number 1.

SELECT SUSER_ID ('DBA') FROM iq_dummy

The following statement returns the user identification number 0.

SELECT SUSER_ID ('SYS') FROM iq_dummy

Standards and compatibility

SQL/92 Vendor extension.

Sybase Adaptive Server Enterprise function implemented for Sybase IQ.

See also

“SUSER_NAME function [System]”

“USER_ID function [System]”