SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > SESSION AUTHORIZATION
Was this helpful?
SESSION AUTHORIZATION
SET SESSION AUTHORIZATION username | USER | CURRENT_USER
     SESSION_USER | SYSTEM_USER | INITIAL_USER
The SET SESSION AUTHORIZATION statement allows a user with security administrator and operator privilege or who is the DBA of the database to set the effective user for the current session.
The SET SESSION statement must be issued before a transaction commences and the settings apply until that session is completed.
The SET SESSION AUTHORIZATION options are as follows:
username | USER | CURRENT USER | SESSION USER
The user name specified or the current user of the session (Ingres user)
SYSTEM_USER
The operating system user who started the session
INITIAL_USER
The Ingres user ID that started the session
Last modified date: 08/29/2024