USER_ID function [System]

Function

Returns an integer user identification number.

Syntax

USER_ID ( [user-name ] )

Parameters

user-name The user name.

Examples

The following statement returns the user identification number 1:

SELECT USER_ID ('DBA') FROM iq_dummy

The following statement returns the user identification number 0:

SELECT USER_ID ('SYS') FROM iq_dummy

Standards and compatibility

See also

“SUSER_ID function [System]”

“USER_NAME function [System]”