Difference between revisions of "User Management"

From BaseX Documentation
Jump to navigation Jump to search
Line 1: Line 1:
 
==User Management==
 
==User Management==
  
<p>Admin permissions are needed to execute on of the following processes.</p>   
+
<p>Admin permissions are needed to execute one of the following processes.</p>   
 
   
 
   
 
===Creating user 'test' with password 'test'===  
 
===Creating user 'test' with password 'test'===  

Revision as of 13:25, 6 December 2010

User Management

Admin permissions are needed to execute one of the following processes.

Creating user 'test' with password 'test'

> CREATE USER test test

As global permissions, you can set 'none', 'read', 'write', 'create' and 'admin':

Revoking all global permissions from user 'test'

> GRANT none TO test

Valid local permissions are 'none', 'read' and 'write':

Granting write permission on database 'factbook' to user 'test'

> GRANT write ON factbook TO test

Note: 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.

Showing global permissions

> SHOW USERS

Showing local permissions on database 'factbook'

> SHOW USERS ON factbook

Dropping of user 'test'

> DROP USER test

Permissions hierarchy

Permissions hierarchy

Commands and Permissions table