Bureaucrats, editor, reviewer, Administrators
13,554
edits
Changes
Jump to navigation
Jump to search
→DROP USER
==DROP USER==
Updated with {{Version|8.0}}: the database argument was changed to a glob pattern argument.
{| width='100%'
|-
|width='130'|'''Syntax'''
|{{Code|DROP USER [name] (ON [databasepattern])}}:
|-
| '''XML Syntax'''
|<code><drop-user name='...' (databasepattern='...')/></code><br/>
|-
| '''Permission'''
|-
| '''Summary'''
|Drops the user with the specified {{Code|[name]}}. If a {{Code|[database]}} is specified, the user is only dropped locally. The [[#Glob Syntax|Glob Syntax]] can be used to address more than one database or user. If a glob {{Code|[pattern]}} is specified, only the pattern will be removed.
|-
| '''Errors'''
|The command fails if {{Code|admin}} is specified as user name, or if the specified user does not exist or is logged in, or if the optional database could not be opened for modification.
|}
