SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > Session Authorization
Was this helpful?
Session Authorization
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
The user name specified
USER | CURRENT USER | SESSION USER
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: 01/30/2023