SET SESSION AUTHORIZATION

The SET SESSION AUTHORIZATION statement changes the value of the SESSION USER and USER special registers. It also changes the name of the user profile associated with the current thread.

Examples:

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

For more information, see SET SESSION AUTHORIZATION in the SQL Reference topic in the Information CenterLink to Information center.