Bureaucrats, editor, reviewer, Administrators
13,554
edits
Changes
Jump to navigation
Jump to search
→GRANT
==GRANT==
Updated with {{Version|8.0}}: the database argument was changed to a glob pattern argument.
{| width='100%'
|-
|width='130'|'''Syntax'''
|{{Code|GRANT [NONE|READ|WRITE|CREATE|ADMIN] (ON [databasepattern]) TO [user]}}
|-
| '''XML Syntax'''
|<code><grant name='...' permission='none|read|write|create|admin' (databasepattern='...')/></code><br/>
|-
| '''Permission'''
|-
| '''Summary'''
|Grants the specified [[User_Management|permission]] to the specified {{Code|[user]}}. If a {{Code|[database]}} is specified, the permissions are only granted locally. The [[#Glob Syntax|Glob Syntax]] can be used to address more than one database or user. If a glob {{Code|[pattern]}} is specified, the permission will be applied to all databases that match this pattern.
|-
| '''Errors'''
|The command fails if {{Code|admin}} is specified as user name, or if the specified user does not exist, or if the optional database could not be opened for modification.
|-
| '''Examples'''
