USER special register
The USER special register specifies the runtime authorization ID that is used for the current session.
The data type of the register is VARCHAR(128). If the length of the authorization ID is less than 8 bytes, the special register value is padded with trailing blanks such that the length is 8 bytes.
USER is a synonym for the SESSION_USER special register. SESSION_USER is the preferred spelling.
Example: Select all notes from the
IN_TRAY
table
that were placed there by the user. SELECT * FROM IN_TRAY
WHERE SOURCE = USER