DCL

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

SYSCTL REPORT STATUS​

Syntax:

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

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

SYSCTL ALTER USER​

Syntax:

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

warning

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

SYSCTL DROP USER​

Syntax:

  1. SYSCTL DROP USER <username>
  • Access control:root only
  • Returns: empty or error