Skip to main content

USER (SQL)

A function that returns the user name of the current user.

Synopsis

USER

{fn USER}
{fn USER()}

Description

USER takes no arguments and returns the user name (also referred to as the authorization ID) of the current user. The general function does not allow parentheses; the ODBC scalar function can specify or omit the empty parentheses.

A user name is defined with the CREATE USER command.

Typical uses for USER are in the SELECT statement select list or in the WHERE clause of a query. In designing a report, USER can be used to print the current user for whom the report is being produced.

Examples

The following example returns the current user name:

SELECT USER AS CurrentUser

The following example selects those records where the last name ($PIECE(Name,',',1) or the first name (without the middle initial) matches the current user name:

SELECT Name FROM Sample.Person 
WHERE %SQLUPPER(USER)=%SQLUPPER($PIECE(Name,',',1)) 
OR %SQLUPPER(USER)=%SQLUPPER($PIECE($PIECE(Name,',',2),' ',1))

See Also

Purpose of this instance: Draft documentation
DocReleaseID: IRIS2025.1
Content loaded from:
/staging/learning/iris-doc/2025.1.x/doc/cache/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/ensemble/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/security/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/iris/en-us/src/
Excluded items: EAST, EDICOM, EHL72, EHL7T, HXHCINST, HXHCRN, HXIHINST, HXIHRN, PAGE_healthcare
FeedbackOpens in a new tab