MariaDB/SQL/GRANT: Difference between revisions

Latest revision as of 01:59, 26 April 2026

GRANT ALL ON `roundcube`.* to 'rc-bot'@localhost;
GRANT ALL PRIVILEGES ON `woozdev-mw`.* TO 'wooz-dev-mw'@'localhost' IDENTIFIED BY 'Template:Arg';

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 6: / Line 6: @@
 ==Example==
 * <syntaxhighlight inline lang=SQL>GRANT ALL ON `roundcube`.* to 'rc-bot'@localhost;</syntaxhighlight>
+* <syntaxhighlight inline lang=SQL>GRANT ALL PRIVILEGES ON `woozdev-mw`.* TO 'wooz-dev-mw'@'localhost' IDENTIFIED BY '</syntaxhighlight>{{arg|password}}<code>'</code>;
 ==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}} ]