SET SESSION AUTHORIZATION
Sets the user name for the current session.
You can use the SET SESSION AUTHORIZATION command, for example, to test database access by temporarily running a session or transaction as an unprivileged user. You must be a database superuser to run this command.
Syntax
SET [ LOCAL ] SESSION AUTHORIZATION { user_name | DEFAULT }
Parameters
- LOCAL
-
Specifies that the setting is valid for the current transaction. Omitting this parameter specifies that the setting is valid for the current session.
- user_name
-
Name of the user to set. The user name may be written as an identifier or a string literal.
- DEFAULT
-
Sets the session user name to the default value.
Examples
The following example sets the user name for the current session to
dwuser:
SET SESSION AUTHORIZATION 'dwuser';The following example sets the user name for the current transaction to
dwuser:
SET LOCAL SESSION AUTHORIZATION 'dwuser';This example sets the user name for the current session to the default user name:
SET SESSION AUTHORIZATION DEFAULT;