Changes

Jump to navigation Jump to search
2,266 bytes added ,  02:36, 6 May 2011
no edit summary
Database commands can be either run from the [[Startup_Options#BaseX_Standalone|Command Line]],
the [[Language Bindings]], [[JAX-RX]], the input field in the [[GUI_Tutorial|GUI]], or
in many other ways. If the client/server environment is used, someThe [[User_Management#Command_Permissions|permissionsPermission]] may be needed in the commanddefinitions indicates which rights are required by a user to execute perform a specific commandin theclient/server architecture.
If the GUI is used, all commands that are triggered by the GUI itself will show up in the [[GUI_Views|Info View]].
| valign='top' width='90' | '''Signature'''
|<code>ADD (AS [name]) (TO [target]) [input]</code>
|-
| valign='top' | '''Permission'''
|<code>WRITE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>ALTER DATABASE [name] [newname]</code>
|-
| valign='top' | '''Permission'''
|<code>CREATE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>ALTER USER [name] ([password])</code>
|-
| valign='top' | '''Permission'''
|<code>ADMIN</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>BACKUP [name]</code>
|-
| valign='top' | '''Permission'''
|<code>CREATE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>CHECK [input]</code>
|-
| valign='top' | '''Permission'''
|<code>CREATE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>CLOSE </code>
|-
| valign='top' | '''Permission'''
|<code>NONE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>COPY [name] [newname]</code>
|-
| valign='top' | '''Permission'''
|<code>CREATE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>CREATE DATABASE [name] ([input])</code>
|-
| valign='top' | '''Permission'''
|<code>CREATE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>CREATE INDEX [TEXT&#124;ATTRIBUTE&#124;FULLTEXT&#124;PATH]</code>
|-
| valign='top' | '''Permission'''
|<code>WRITE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>CREATE USER [name] ([password])</code>:
|-
| valign='top' | '''Permission'''
|<code>ADMIN</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>CS [query]</code>
|-
| valign='top' | '''Permission'''
|''depends on query''
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>DELETE [path]</code>
|-
| valign='top' | '''Permission'''
|<code>WRITE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>DROP BACKUP [name]</code>
|-
| valign='top' | '''Permission'''
|<code>CREATE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>DROP DATABASE [name]</code>
|-
| valign='top' | '''Permission'''
|<code>CREATE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>DROP INDEX [PATH&#124;TEXT&#124;ATTRIBUTE&#124;FULLTEXT]</code>
|-
| valign='top' | '''Permission'''
|<code>WRITE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>DROP USER [name] (ON [database])</code>:
|-
| valign='top' | '''Permission'''
|<code>ADMIN</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>EXIT </code>
|-
| valign='top' | '''Permission'''
|<code>NONE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>EXPORT [path]</code>
|-
| valign='top' | '''Permission'''
|<code>CREATE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>FIND [keywords]</code>
|-
| valign='top' | '''Permission'''
|<code>READ</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>GET [option]</code>
|-
| valign='top' | '''Permission'''
|<code>NONE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>GRANT [NONE&#124;READ&#124;WRITE&#124;CREATE&#124;ADMIN] (ON [database]) TO [user]</code>
|-
| valign='top' | '''Permission'''
|<code>ADMIN</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>HELP ([command])</code>
|-
| valign='top' | '''Permission'''
|<code>NONE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>INFO</code>
|-
| valign='top' | '''Permission'''
|<code>READ</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>INFO DATABASE</code>
|-
| valign='top' | '''Permission'''
|<code>READ</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>INFO INDEX ([TEXT|ATTRIBUTE|FULLTEXT|PATH])</code>
|-
| valign='top' | '''Permission'''
|<code>READ</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>INFO STORAGE [start end] | [query]</code>
|-
| valign='top' | '''Permission'''
|<code>READ</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>KILL [name]</code>
|-
| valign='top' | '''Permission'''
|<code>ADMIN</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>LIST ([path])</code>
|-
| valign='top' | '''Permission'''
|<code>NONE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>OPEN [path]</code>
|-
| valign='top' | '''Permission'''
|<code>READ</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>OPTIMIZE (ALL)</code>
|-
| valign='top' | '''Permission'''
|<code>WRITE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>PASSWORD ([password])</code>
|-
| valign='top' | '''Permission'''
|<code>NONE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>RESTORE [name]</code>
|-
| valign='top' | '''Permission'''
|<code>CREATE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>RUN [file]</code>
|-
| valign='top' | '''Permission'''
|''depends on query''
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>SET [option] ([value])</code>
|-
| valign='top' | '''Permission'''
|<code>NONE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>SHOW BACKUPS</code>
|-
| valign='top' | '''Permission'''
|<code>CREATE</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>SHOW DATABASES</code>
|-
| valign='top' | '''Permission'''
|<code>ADMIN</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>SHOW SESSIONS</code>
|-
| valign='top' | '''Permission'''
|<code>ADMIN</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>SHOW USERS (ON [database])</code>
|-
| valign='top' | '''Permission'''
|<code>ADMIN</code>
|-
| valign='top' | '''Summary'''
| valign='top' width='90' | '''Signature'''
|<code>XQUERY [query]</code>
|-
| valign='top' | '''Permission'''
|''depends on query''
|-
| valign='top' | '''Summary'''
Bureaucrats, editor, reviewer, Administrators
13,554

edits

Navigation menu