GRANT

Overview

Assigns privileges to a user account or security role.

USAGE

DETAILS

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

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

  • The _ and % wildcards are not supported in database name specifications

  • Values supplied for column_list and object_type are ignored

  • 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

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