MariaDB/SQL/GRANT - Revision history

Woozle at 01:59, 26 April 2026

2026-04-26T01:59:04Z

← Older revision		Revision as of 01:59, 26 April 2026
Line 6:		Line 6:
	==Example==		==Example==
	* <syntaxhighlight inline lang=SQL>GRANT ALL ON `roundcube`.* to 'rc-bot'@localhost;</syntaxhighlight>		* <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}} ]

Woozle: /* Example */ backticks

2025-04-13T17:36:01Z

Example: backticks

← Older revision		Revision as of 17:36, 13 April 2025
Line 5:		Line 5:
	* [https://mariadb.com/kb/en/grant/ MariaDB Knowledge Base]		* [https://mariadb.com/kb/en/grant/ MariaDB Knowledge Base]
	==Example==		==Example==
	* <syntaxhighlight inline lang=SQL>GRANT ALL ON roundcube.* to 'rc-bot'@localhost;</syntaxhighlight>		* <syntaxhighlight inline lang=SQL>GRANT ALL ON `roundcube`.* to 'rc-bot'@localhost;</syntaxhighlight>

	==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}} ]

Woozle at 18:53, 16 February 2025

2025-02-16T18:53:39Z

← Older revision		Revision as of 18:53, 16 February 2025
Line 2:		Line 2:
	* <code>{{l/same\|REVOKE}}</code> negates privileges granted by <code>GRANT</code>.		* <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>)		* <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==		==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}} ]

Woozle at 18:08, 16 February 2025

2025-02-16T18:08:46Z

← Older revision		Revision as of 18:08, 16 February 2025
Line 8:		Line 8:
	*** <code>USAGE</code>		*** <code>USAGE</code>
	*** <code>ALL</code> [<code>PRIVILEGES</code>]		*** <code>ALL</code> [<code>PRIVILEGES</code>]
	*** <code>GRANT OPTION</code>
	** '''{{fmt/arg\|object type}}''': ''one of –''		** '''{{fmt/arg\|object type}}''': ''one of –''
	*** <code>TABLE</code>		*** <code>TABLE</code>
Line 25:		Line 24:
	*** {{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 –''		** '''{{fmt/arg\|authentication option}}''': ''one of –''
	*** <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 –''
			*** <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 –''
			*** <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 –''		** '''{{fmt/arg\|grantee}}''': ''one of –''
	*** {{fmt/arg\|rolename}}		*** {{fmt/arg\|rolename}}
	*** {{fmt/arg\|username}} {{fmt/arg/opt\|authentication option}}		*** {{fmt/arg\|username}} {{fmt/arg/opt\|authentication option}}

Woozle at 18:02, 16 February 2025

2025-02-16T18:02:52Z

← Older revision		Revision as of 18:02, 16 February 2025
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==		==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 –''
			*** <code>USAGE</code>
			*** <code>ALL</code> [<code>PRIVILEGES</code>]
			*** <code>GRANT OPTION</code>
	** '''{{fmt/arg\|object type}}''': ''one of –''		** '''{{fmt/arg\|object type}}''': ''one of –''
	*** <code>TABLE</code>		*** <code>TABLE</code>

Woozle: Created page with "==Syntax== * `GRANT` {{fmt/arg|priv list}} `ON` {{fmt/arg|object type}} {{fmt/arg|priv level}} `TO` {{fmt/arg|user spec}} [ {{fmt/arg|user opt..."

2025-02-16T17:54:31Z

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..."

New page

==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|object type}}''': ''one of –''
*** <code>TABLE</code>
*** <code>FUNCTION</code>
*** <code>PROCEDURE</code>
*** <code>PACKAGE</code>
*** <code>PACKAGE BODY</code>
** '''{{fmt/arg|priv level}}''': ''one of –''
*** <code>*</code>
*** <code>*.*</code>
*** {{fmt/arg|db_name}}<code>.*</code>
*** {{fmt/arg|db_name}}<code>.</code>{{fmt/arg|tbl_name}}
*** {{fmt/arg|tbl_name}}
*** {{fmt/arg|db_name}}<code>.</code>{{fmt/arg|routine_name}}
** '''{{fmt/arg|user spec}}''': ''one of –''
*** {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}
*** <code>PUBLIC</code>
** '''{{fmt/arg/opt|authentication option}}''': ''one of –''
*** <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...'']
* <code>GRANT</code> {{fmt/arg|rolename}} <code>TO</code> {{fmt/arg|grantee}} [, ''repeat...''] [<code>WITH ADMIN OPTION</code>]
** '''{{fmt/arg|grantee}}''': ''one of –''
*** {{fmt/arg|rolename}}
*** {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}