Examples

Example 1: The following statement sets the SESSION_USER special register.

   SET SESSION_USER = RAJIV

Example 2: Set the session authorization ID (the SESSION_USER special register) to be the value of the system authorization ID, which is the ID that established the connection on which the statement has been issued.

   SET SESSION AUTHORIZATION SYSTEM_USER