MariaDB/SQL/GRANT

Related

• REVOKE negates privileges granted by GRANT.
• SHOW GRANTS lists privileges granted by GRANT. (see SHOW)

Reference

• MariaDB Knowledge Base

Example

• GRANT ALL ON `roundcube`.* to 'rc-bot'@localhost;

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> ]