Last modified February 12, 2025

DatabaseAssign

This function allows you to assign database and database users to an account.
Parameters
Parameter name Type Description Possible Values Example
account String REQUIRED The account to assign databases/database users to.   account=exampleAccount
type Integer REQUIRED The database type.
  • MySQL: type=1
  • MongoDB: type=2
  • PostgreSQL: type=3
 type=1
list Integer REQUIRED The list of databases/database users to assign. All possible value must be included and can be empty.
  • list[databases][assigned][0]
  • list[databases][unassigned][0]
  • list[users][assigned][0]
  • list[users][unassigned][0]
    		•  list[databases][assigned][0]=exampleDB&list[databases][unassigned][0]=&list[users][assigned][0]=exampleDBUser&list[users][unassigned][0]="

    Example Call JETAPI

    jetbackup5api -F Plugin/ManageDatabases/DatabaseAssign -D "type=2&list[databases][assigned][0]={$DATABASE}&list[databases][unassigned][0]=&list[users][assigned][0]={$DATABASE_USER}&list[users][unassigned][0]=&account={$ACCOUNT_NAME}"
    success: 1
message: Database reassigned successfully
system:
  version: 5.3.15.0
  version_panel: 5.3.15.0
  tier: RELEASE
  type: Linux
  retry_ms: 0
  disableui:
  dr:
  agreement_panel:
  agreement:
  licenseIssue:
data:

    Example Call HTTP

    https://HOST_NAME:3035/?api=1&function=Plugin/ManageDatabases/DatabaseAssign&type=2&list[databases][assigned][0]={$DATABASE}&list[databases][unassigned][0]=&list[users][assigned][0]={$DATABASE_USER}&list[users][unassigned][0]=&account={$ACCOUNT_NAME}