SESSION_USER

Return the current user name. This function returns the user name and host name as provided by the client when connecting.

Syntax

SESSION_USER()

Description

Current

Shows the value of CURRENT_USER() when the session was created, that is, it shows a user@host pair from the mysql.global_priv table, like CURRENT_USER(), but unlike CURRENT_USER() it will not change inside stored routines and views. This is SQL Standard behavior for the SESSION_USER function.

< 11.7

SESSION_USER() is a synonym for USER().

Backward-compatible behavior can be restored by setting old mode to SESSION_USER_IS_USER.

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}