MariaDB/SQL/GRANT

Syntax

GRANT <priv list> ON <object type> <priv level> TO <user spec> [ <user options> ]
- <priv list>: <priv_type> [ <column_list> ] [, repeat...]
- <priv_type>: one of –
  - USAGE
  - ALL [PRIVILEGES]
- <object type>: one of –
  - TABLE
  - FUNCTION
  - PROCEDURE
  - PACKAGE
  - PACKAGE BODY
- <priv level>: one of –
  - *
  - *.*
  - <db_name>.*
  - <db_name>.<tbl_name>
  - <tbl_name>
  - <db_name>.<routine_name>
- <user spec>: one of –
  - <username> [ <authentication option> ]
  - PUBLIC
- <authentication option>: one of –
  - IDENTIFIED BY '<password>'
  - IDENTIFIED BY PASSWORD 'password_hash'
  - IDENTIFIED {VIA|WITH} <authentication rule> [OR repeat...]
- <user option>: one of –
  - REQUIRE {NONE | <TLS option> [[AND] repeat...]
  - [WITH <with option> [repeat...]
- <with option>: one of –
  - GRANT OPTION
  - <resource_option>
GRANT <rolename> TO <grantee> [, repeat...] [WITH ADMIN OPTION]
- <grantee>: one of –
  - <rolename>
  - <username> [ <authentication option> ]