Returns the numeric user ID for the specified user name.

Syntax

SUSER_ID( [ user-name ] )

Parameters

Returns

INT

Remarks

If you do not specify user-name, the ID of the current user is returned.

See also

• SUSER_NAME function [System]
• USER_ID function [System]

Standards and compatibility

Example

The following statement returns the ID for the GROUPO user.

SELECT SUSER_ID( 'GROUPO' );