Skip to main content
Version: Next

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