ALTER USER

Overview

Modifies user characteristics, including changing and setting account authentication, TLS restrictions, and password expiration.

See also: SQL Statements for MariaDB Xpand 6.1, in 6.0, and in 5.3

See also: SQL Statements for MariaDB Xpand 6.0 and in 5.3

See also: SQL Statements for MariaDB Xpand 6.1

USAGE

DETAILS

MariaDB Xpand's ALTER USER statement has some differences from MariaDB Enterprise Server:

  • The user account can't be specified using CURRENT_USER, CURRENT_USER(), or SESSION_USER()

  • TLS options specified with REQUIRE .. are ignored

  • The following resource limit options are not supported and cause a syntax error to be raised:

    • MAX_QUERIES_PER_HOUR

    • MAX_UPDATES_PER_HOUR

    • MAX_CONNECTIONS_PER_HOUR

    • MAX_USER_CONNECTIONS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

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