Vultr Customer Portal

1. Navigate to Products and select Databases.
2. Select the target database.
3. Navigate to Topic & Users to manage Users for Vultr Managed Apache Kafka®.
4. Click Add New User.
5. Provide values for Username, Permissions, and Password.
6. Click Create New User.

Vultr API

1. List all the databases by sending a GET request to the List Managed Databases endpoint and note the target database’s ID.
   console

   $ curl "https://api.vultr.com/v2/databases" \
       -X GET \
       -H "Authorization: Bearer ${VULTR_API_KEY}"
   

2. Send a POST request to the Create Database User endpoint to create a new user for your database.
   console

   $ curl "https://api.vultr.com/v2/databases/<database-id>/users" \ 
       -X POST \
       -H "Authorization: Bearer ${VULTR_API_KEY}" \
       -H "Content-Type: application/json" \
       --data '{
           "username": "user1",
           "password": "p@ssWord123#",
           "permission": "readwrite"
   }'
   

3. Send a GET request to the List Database Users endpoint to list all the users.
   console

   $ curl "https://api.vultr.com/v2/databases/<database-id>/users" \
       -X GET \
       -H "Authorization: Bearer ${VULTR_API_KEY}"
   

4. Send a DELETE request to Delete Database User endpoint
   console

   $ curl "https://api.vultr.com/v2/databases/{database-id}/users/{username}" \
       -X DELETE \
       -H "Authorization: Bearer ${VULTR_API_KEY}"

Vultr CLI

1. List all databases and note the target database’s ID.
   console

   $ vultr-cli database list --summarize
   

2. List all the users.
   console

   $ vultr-cli database user list <database-id>
   

3. Delete a user.
   console

   $ vultr-cli database user delete <database-id> <user-name>
   

   Run vultr-cli database update --help to view all options.

Terraform

1. Ensure the Vultr Terraform provider is configured.
2. Create a Kafka user with Terraform.
   terraform

   terraform {
       required_providers {
           vultr = {
               source  = "vultr/vultr"
               version = "~> 2.26"
           }
       }
   }
   
   provider "vultr" {}
   
   # Existing database assumed
   variable "database_id" { type = string }
   
   resource "vultr_database_user" "kafka_user" {
       database_id = var.database_id
       username    = "user1"
       password    = "p@ssWord123#"
       permission = "readwrite"
   }
   

3. To delete the user, remove the resource block or run:
   console

   $ terraform destroy -target vultr_database_user.kafka_user