CURRENT_USER()

Overview

Returns the user and host of the current client connection.

USAGE

CURRENT_USER()

DETAILS

CURRENT_USER() is an information function that returns the user name and host name (separated by @) that was used by the server to authenticate the current client connection.

The return value is a string in the utf8 character set.

The user returned can differ from that of USER() since the authenticating user may not exactly match the name in the authentication request.

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

SELECT CURRENT_USER();
+----------------+
| CURRENT_USER() |
+----------------+
| 'tester'@'%'   |
+----------------+

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.09

  • Present starting in MariaDB Xpand 23.09.1.

6.1

  • Present starting in MariaDB Xpand 6.1.0.

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.1

  • Present starting in MariaDB Xpand 6.1.0.

EXTERNAL REFERENCES