USER
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. For an explanation of authorization ID translation, see DB2 Administration Guide. 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;