doctl databases user list

Go to Navigation


doctl databases user list <database-cluster-id> [flags]




Retrieves a list of users for the specified database with the following details:

  • The username for the user
  • The password for the user
  • The user’s role, either “primary” or “normal”

Primary user accounts are created by DigitalOcean at database cluster creation time and can’t be deleted. You can create additional users with a “normal” role. Both have administrative privileges on the database cluster.

To retrieve a list of your databases and their IDs, call doctl databases list.


The following example retrieves a list of users for a database cluster with the ID ca9f591d-f38h-5555-a0ef-1c02d1d1e35 and uses the --format flag to return only the name and role for each each user:

doctl databases user list ca9f591d-f38h-5555-a0ef-1c02d1d1e35 --format Name,Role


Option Description
--format Columns for output in a comma-separated list. Possible values: Name, Role, Password.
--help , -h Help for this command
--no-header Return raw data with no headers
Default: false
Command Description
doctl databases user Display commands for managing database users

Global Flags

Option Description
--access-token, -t API V2 access token
--api-url, -u Override default API endpoint
--config, -c Specify a custom config file
  • macOS: ${HOME}/Library/Application Support/doctl/config.yaml
  • Linux: ${XDG_CONFIG_HOME}/doctl/config.yaml
  • Windows: %APPDATA%\doctl\config.yaml
--context Specify a custom authentication context name
--http-retry-max Set maximum number of retries for requests that fail with a 429 or 500-level error
Default: 5
--http-retry-wait-max Set the minimum number of seconds to wait before retrying a failed request
Default: 30
--http-retry-wait-min Set the maximum number of seconds to wait before retrying a failed request
Default: 1
--interactive Enable interactive behavior. Defaults to true if the terminal supports it (default false)
Default: false
--output, -o Desired output format [text|json]
Default: text
--trace Show a log of network activity while performing a command
Default: false
--verbose, -v Enable verbose output
Default: false