MariaDB/SQL/GRANT: Difference between revisions

Revision as of 18:02, 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]
  - GRANT OPTION
- 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/opt: one of –
  - IDENTIFIED BY 'Template:Fmt/arg'
  - IDENTIFIED BY PASSWORD 'password_hash'
  - IDENTIFIED {VIA|WITH} Template:Fmt/arg [OR repeat...]
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 1: / Line 1: @@
+==Related==
+* <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>)
 ==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}} ]
 ** '''{{fmt/arg|priv list}}''': {{fmt/arg|priv_type}} {{fmt/arg/opt|column_list}} [, ''repeat...'']
+** '''{{fmt/arg|priv_type}}''': ''one of &ndash;''
+*** <code>USAGE</code>
+*** <code>ALL</code> [<code>PRIVILEGES</code>]
+*** <code>GRANT OPTION</code>
 ** '''{{fmt/arg|object type}}''': ''one of &ndash;''
 *** <code>TABLE</code>