Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
==='''Creating user 'test' with password 'test'=== :'''
==='''Revoking all global permissions from user 'test'=== : '''
==='''Granting write permission on database 'factbook' to user 'test'=== : '''
==='''Showing global permissions=== :'''
==='''Showing local permissions on database 'factbook'=== :'''
==='''Dropping of user 'test'=== :'''
no edit summary
Admin permissions are needed to execute one of the following processes.
<code>> CREATE USER test test</code>
As global permissions, you can set 'none', 'read', 'write', 'create' and 'admin':
<code>> GRANT none TO test</code>
Valid local permissions are 'none', 'read' and 'write':
<code>> GRANT write ON factbook TO test</code>
inherited.
<code>> SHOW USERS</code>
<code>> SHOW USERS ON factbook</code>
<code>> DROP USER test</code>
[[Category:Server]]
