CLIENT_ORIGUSERID global variable

This built-in global variable contains the original user identifier, as supplied by an application, usually from a multiple-tier server environment.

This global variable has the following characteristics:
  • It is read-only, with values maintained by system.
  • The type is VARCHAR(1024).
  • The schema is SYSIBM.
  • The scope of this global variable is session.

If an application does not supply a value, the value of the CLIENT_ORIGUSERID global variable is NULL.

The value that is used for CLIENT_ORIGUSERID can be set with the following APIs:
  • the originalUser variable of the getDB2Connection (trusted reuse) and reuseDB2Connection (trusted connection reuse) APIs of the IBM® Data Server Driver for JDBC and SQLJ.

Notes

No privileges are granted to PUBLIC when the CLIENT_ORIGUSERID global variable is created.