bueraucrat, Bureaucrats, editor, reviewer, Administrators
907
edits
Changes
Jump to navigation
Jump to search
Created page with "==User Management== <blockquote> ===Creating user 'test' with password 'test'=== <code>> CREATE USER test test</code> <p>As global permissions, you can set 'none', 'read..."
==User Management==
<blockquote>
===Creating user 'test' with password 'test'===
<code>> CREATE USER test test</code>
<p>As global permissions, you can set 'none', 'read', 'write', 'create' and 'admin':</p>
<h4>Revoking all global permissions from user 'test'</h4>
<code>> GRANT none TO test</code>
<p>Valid local permissions are 'none', 'read' and 'write':</p>
===Granting write permission on database 'factbook' to user 'test'===
<code>> GRANT write ON factbook TO test</code>
<p>
Note that local permissions overwrite global permissions.
As a consequence, the 'test' user will only be allowed to
access (i.e., read and write) the 'factbook' database.
If no local permissions are set, the global rights are
inherited.
</p>
<p>Admin permissions are needed to review the user permissions:</p>
===Showing global permissions===
<code>> SHOW USERS</code>
===Showing local permissions on database 'factbook'===
<code>> SHOW USERS ON factbook</code>
<p/>
</blockquote>
<blockquote>
===Creating user 'test' with password 'test'===
<code>> CREATE USER test test</code>
<p>As global permissions, you can set 'none', 'read', 'write', 'create' and 'admin':</p>
<h4>Revoking all global permissions from user 'test'</h4>
<code>> GRANT none TO test</code>
<p>Valid local permissions are 'none', 'read' and 'write':</p>
===Granting write permission on database 'factbook' to user 'test'===
<code>> GRANT write ON factbook TO test</code>
<p>
Note that local permissions overwrite global permissions.
As a consequence, the 'test' user will only be allowed to
access (i.e., read and write) the 'factbook' database.
If no local permissions are set, the global rights are
inherited.
</p>
<p>Admin permissions are needed to review the user permissions:</p>
===Showing global permissions===
<code>> SHOW USERS</code>
===Showing local permissions on database 'factbook'===
<code>> SHOW USERS ON factbook</code>
<p/>
</blockquote>
