MariaDB/SQL/GRANT: Difference between revisions

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Woozle (talk | contribs)
Bureaucrats, Interface administrators, interwiki, Administrators, trusted
20,099 edits
VisualWikitext
Created page with "==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 opt..."
 
No edit summary
 
(4 intermediate revisions by the same user not shown)
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>)
==Reference==
* [https://mariadb.com/kb/en/grant/ MariaDB Knowledge Base]
==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==
==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}} ]
* <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 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>]
** '''{{fmt/arg|object type}}''': ''one of &ndash;''
** '''{{fmt/arg|object type}}''': ''one of &ndash;''
*** <code>TABLE</code>
*** <code>TABLE</code>
Line 18: Line 29:
*** {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}
*** {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}
*** <code>PUBLIC</code>
*** <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</code> '{{fmt/arg|password}}'  
*** <code>IDENTIFIED BY PASSWORD</code> 'password_hash'
*** <code>IDENTIFIED BY PASSWORD</code> 'password_hash'
*** <code>IDENTIFIED</code> {<code>VIA</code>|<code>WITH</code>} {{fmt/arg|authentication rule}} [OR ''repeat...'']
*** <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>]
* <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|grantee}}''': ''one of &ndash;''
*** {{fmt/arg|rolename}}
*** {{fmt/arg|rolename}}
*** {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}
*** {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}

Latest revision as of 01:59, 26 April 2026

  • [[../REVOKE|REVOKE]] negates privileges granted by GRANT.
  • [[../SHOW GRANTS|SHOW GRANTS]] lists privileges granted by GRANT. (see [[../SHOW|SHOW]])

Reference

Example

  • GRANT ALL ON `roundcube`.* to 'rc-bot'@localhost;
  • GRANT ALL PRIVILEGES ON `woozdev-mw`.* TO 'wooz-dev-mw'@'localhost' IDENTIFIED BY '<password>';

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> ]
Retrieved from "https://htyp.org/mw/index.php?title=MariaDB/SQL/GRANT&oldid=29397"