SET SESSION AUTHORIZATION#
Synopsis#
SET SESSION AUTHORIZATION username
Description#
Changes the current user of the session. For the SET SESSION AUTHORIZATION username
statement to succeed, the original user (that the client connected
with) must be able to impersonate the specified user. User impersonation can be
enabled in the system access control.
Examples#
In the following example, the original user when the connection to Trino is made is Kevin. The following sets the session authorization user to John:
SET SESSION AUTHORIZATION 'John';
Queries will now execute as John instead of Kevin.
All supported syntax to change the session authorization users are shown below.
Changing the session authorization with single quotes:
SET SESSION AUTHORIZATION 'John';
Changing the session authorization with double quotes:
SET SESSION AUTHORIZATION "John";
Changing the session authorization without quotes:
SET SESSION AUTHORIZATION John;