User Management
Jump to navigation
Jump to search
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
Commands and Permissions table
Command | Description | Needed Permission |
---|---|---|
close | Closes currently opened database. | None |
exit | Exits BaseX. | None |
get | Returns a property value. | None |
help | Shows the help texts. | None |
password | Changes password of currently logged-in user. | None |
set | Sets a property value. | None |
xquery | Executes a xquery function without database access. | None |
info | Shows information about the currently opened database. | Read |
list | Shows all available databases. | Read |
open | Opens a database. | Read |
xquery | Executes a read-only xquery function with database access. | Read |
add | Adds documents to the currently opened database. | Write |
create index | Creates the specified index. | Write |
delete | Deletes documents from the currently opened database. | Write |
drop index | Drops the specified index. | Write |
optimize | Optimizes the database structure and renews the indexes. | Write |
xquery | Executes a xquery update function. | Write |
alter db | Renames a database. | Create |
create db | Creates a database. | Create |
drop db | Drops a database. | Create |
export | Exports the database content. | Create |
alter user | Changes the password of an user. | Admin |
create users | Creates a new user. | Admin |
drop user | Drops an user. | Admin |
grant | Assigns permissions to users. | Admin |
kill | Kills an user session on the server. | Admin |
show | Shows different server information. | Admin |