GRANT

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

RELATED TOPICS

• Privileges for MariaDB Xpand

• REVOKE

• SHOW GRANTS

CHANGE HISTORY