DB2 Version 9.7 for Linux, UNIX, and Windows

SESSION_USER special register

The SESSION_USER special register specifies the current run-time authorization ID that is being 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.

The initial value of SESSION_USER for a new connection is the same as the value of the SYSTEM_USER special register. Its value can be changed by invoking the SET SESSION AUTHORIZATION statement.

SESSION_USER is a synonym for the USER special register.

Example: Determine what routines can be executed by current run-time authorization ID if it were to issue invocations through dynamic SQL.

   SELECT SCHEMA, SPECIFICNAME FROM SYSCAT.ROUTINEAUTH
     WHERE GRANTEE = SESSION_USER
     AND EXECUTEAUTH IN ('Y', 'G')