Changes

Jump to navigation Jump to search
No change in size ,  13:24, 6 December 2010
no edit summary
<code>&gt; GRANT write ON factbook TO test</code>
<p>
Note that local : 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===
===Showing local permissions on database 'factbook'===
<code>&gt; SHOW USERS ON factbook</code>
 
<p>Note: Admin permissions are needed to review the user permissions.</p>
===Dropping of user 'test'===
bueraucrat, Bureaucrats, editor, reviewer, Administrators
907

edits

Navigation menu