SET USER - Kinetica Docs

The SET USER (or SETUSER) command is simply an alias for the EXECUTE AS and REVERT commands.

This command is only available through KiSQL or database clients configured with the Kinetica ODBC/JDBC driver.

The following commands are equivalent for switching to another user:

SET USER Syntax

< < SET USER <user name> > | < EXECUTE AS USER = '<user name>' > >

There is no ability to prevent reversion to the original user when using the SET USER command. To prevent reversion, see EXECUTE AS.

The following commands are equivalent for switching back to the original user:

Revert User Syntax

< SET USER | REVERT >