MariaDB/SQL/GRANT: Difference between revisions

Revision as of 18:53, 16 February 2025

GRANT Template:Fmt/arg ON Template:Fmt/arg Template:Fmt/arg TO Template:Fmt/arg [ Template:Fmt/arg ]
- Template:Fmt/arg: Template:Fmt/arg Template:Fmt/arg/opt [, repeat...]
- Template:Fmt/arg: one of –
  - USAGE
  - ALL [PRIVILEGES]
- Template:Fmt/arg: one of –
  - TABLE
  - FUNCTION
  - PROCEDURE
  - PACKAGE
  - PACKAGE BODY
- Template:Fmt/arg: one of –
  - *
  - *.*
  - Template:Fmt/arg.*
  - Template:Fmt/arg.Template:Fmt/arg
  - Template:Fmt/arg
  - Template:Fmt/arg.Template:Fmt/arg
- Template:Fmt/arg: one of –
  - Template:Fmt/arg Template:Fmt/arg/opt
  - PUBLIC
- Template:Fmt/arg: one of –
  - IDENTIFIED BY 'Template:Fmt/arg'
  - IDENTIFIED BY PASSWORD 'password_hash'
  - IDENTIFIED {VIA|WITH} Template:Fmt/arg [OR repeat...]
- Template:Fmt/arg: one of –
  - REQUIRE {NONE | Template:Fmt/arg [[AND] repeat...]
  - [WITH Template:Fmt/arg [repeat...]
- Template:Fmt/arg: one of –
  - GRANT OPTION
  - Template:Fmt/arg
GRANT Template:Fmt/arg TO Template:Fmt/arg [, repeat...] [WITH ADMIN OPTION]
- Template:Fmt/arg: one of –
  - Template:Fmt/arg
  - Template:Fmt/arg Template:Fmt/arg/opt

@@ Line 2: / Line 2: @@
 * <code>{{l/same|REVOKE}}</code> negates privileges granted by <code>GRANT</code>.
 * <code>{{l/same|SHOW GRANTS}}</code> lists privileges granted by <code>GRANT</code>. (see <code>{{l/same|SHOW}}</code>)
+==Reference==
+* [https://mariadb.com/kb/en/grant/ MariaDB Knowledge Base]
+==Example==
+* <syntaxhighlight inline lang=SQL>GRANT ALL ON roundcube.* to 'rc-bot'@localhost;</syntaxhighlight>
 ==Syntax==
 * <code>GRANT</code> {{fmt/arg|priv list}} <code>ON</code> {{fmt/arg|object type}} {{fmt/arg|priv level}} <code>TO</code> {{fmt/arg|user spec}} [ {{fmt/arg|user options}} ]