MariaDB/SQL/GRANT: Difference between revisions

Revision as of 18:08, 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 8: / Line 8: @@
 *** <code>USAGE</code>
 *** <code>ALL</code> [<code>PRIVILEGES</code>]
-*** <code>GRANT OPTION</code>
 ** '''{{fmt/arg|object type}}''': ''one of &ndash;''
 *** <code>TABLE</code>
@@ Line 25: / Line 24: @@
 *** {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}
 *** <code>PUBLIC</code>
-** '''{{fmt/arg/opt|authentication option}}''': ''one of &ndash;''
+** '''{{fmt/arg|authentication option}}''': ''one of &ndash;''
 *** <code>IDENTIFIED BY</code> '{{fmt/arg|password}}'
 *** <code>IDENTIFIED BY PASSWORD</code> 'password_hash'
 *** <code>IDENTIFIED</code> {<code>VIA</code>|<code>WITH</code>} {{fmt/arg|authentication rule}} [OR ''repeat...'']
+** '''{{fmt/arg|user option}}''':  ''one of &ndash;''
+*** <code>REQUIRE</code> {<code>NONE</code> | {{fmt/arg|TLS option}} [[<code>AND</code>] ''repeat...'']
+*** [<code>WITH</code> {{fmt/arg|with option}} [''repeat...'']
+** '''{{fmt/arg|with option}}''': ''one of &ndash;''
+*** <code>GRANT OPTION</code>
+*** {{fmt/arg|resource_option}}
 * <code>GRANT</code> {{fmt/arg|rolename}} <code>TO</code> {{fmt/arg|grantee}} [, ''repeat...''] [<code>WITH ADMIN OPTION</code>]
 ** '''{{fmt/arg|grantee}}''': ''one of &ndash;''
 *** {{fmt/arg|rolename}}
 *** {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}