USER_ID Function [System]

Returns an integer user identification number.

Syntax

USER_ID ( [ user-name ] )

Parameters

Parameter

Description

user-name

The user name.

Returns

INT

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Adaptive Server function implemented for SAP Sybase IQ.

Example

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
Parent topic: Alphabetical List of Functions
Related reference
SUSER_ID Function [System]
SUSER_NAME Function [System]
USER_NAME Function [System]