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