USER_ID function [System]

Returns an integer user identification number.

USER_ID ( [ user-name ] )

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