SET AND RESET SESSION AUTHORIZATION

These statements set or reset the user of the session to the given or revert the user back to the original authenticated user.

The session user can be changed only if the initial authenticated user had the superuser privileges. Otherwise, the statement is only accepted if the specified username matches the originally authenticated user.

SET LOCAL does not have any effect on session. All statements will be ignored by CrateDB and logged with the INFO logging level.

The DEFAULT and RESET forms reset the session and current user to be the originally authenticated user.

The user name represented as an identifier or a string literal.

DEFAULT