USER_NAME( [ user-id ] ) 

VARCHAR

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

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

The following statement returns the user name for user ID 101.

SELECT USER_NAME( 101 );