USER special register

USER specifies the primary authorization ID of the process. The data type is VARCHAR(128). SESSION_USER is the preferred spelling.

If USER is referred to in an SQL statement that is executed at a remote Db2 and the primary authorization ID has been translated to a different authorization ID, USER specifies the translated authorization ID. The value of USER in a user-defined function or stored procedure is determined according to the rules in Table 1.

Example

Display information about tables, views, and aliases that are owned by the primary authorization ID of the process.

  SELECT * FROM SYSIBM.SYSTABLES WHERE CREATOR = USER;