CONNECTION_AUTHN_INFO global variable

This built-in global variable contains details that are returned from authentication mechanism about the user for the connection.

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

Db2® sets the value as obtained from authentication mechanism specified by users. If users do not provide a value or if the IDP is configured to prevent exposure of the contents, the value of the global variable is null. Only the built-in JWT authentication mechanism provides a value for this global variable. If the client did not connect with JWT authentication, the value of the global variable is null.