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]
  - GRANT OPTION
- <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...]
GRANT <rolename> TO <grantee> [, repeat...] [WITH ADMIN OPTION]
- <grantee>: one of –
  - <rolename>
  - <username> [ <authentication option> ]