Skip to main content
Version: 0.8

DCL

Data Control Language or DCL can be used to perform administrative tasks on the database. Currently, all DCL commands are available under the SYSCTL query.

SYSCTL REPORT STATUS

Syntax:

SYSCTL REPORT STATUS
  • Access control: any
  • Operational notes:
    • This returns the current overall health of the system
  • Returns: empty or string or error

SYSCTL CREATE USER

Syntax:

SYSCTL CREATE USER 'username' WITH { password: 'password' }
  • Access control: root only
  • Returns: empty or error

SYSCTL ALTER USER

Syntax:

SYSCTL ALTER USER 'username' WITH { password: 'new password' }
  • Access control: root only
  • Returns: empty or error
warning

Trying to change the root account password will throw an error. You can only change the root by following the procedure here

SYSCTL DROP USER

Syntax:

SYSCTL DROP USER 'username'
  • Access control: root only
  • Returns: empty or error