---
title: doctl databases user get
description: |-
    Retrieves the following details about the specified user:

    - The username for the user
    - The password for the user
    - The user's role, either "primary" …
product: Reference
url: https://docs.digitalocean.com/reference/doctl/reference/databases/user/get/
last_updated: "2026-10-08"
---

> **For AI agents:** The documentation index is at [https://docs.digitalocean.com/llms.txt](https://docs.digitalocean.com/llms.txt). Markdown versions of pages use the same URL with `index.html.md` in place of the HTML page (for example, append `index.html.md` to the directory path instead of opening the HTML document).

# doctl databases user get

Generated on 8 Oct 2026 from `doctl` version [`v1.179.0`](https://github.com/digitalocean/doctl/releases/tag/v1.179.0)

## Usage

```shell
doctl databases user get <database-cluster-id> <user-name> [flags]
```

## Aliases

```shell
g
```

## Description

Retrieves the following details about the specified user:

- 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`.

To retrieve a list of database users for a database cluster, call `doctl databases user list <database-cluster-id>`.

## Example

The following example retrieves the details for the user with the username `example-user` for a database cluster with the ID `ca9f591d-f38h-5555-a0ef-1c02d1d1e35` and uses the `--format` flag to return only the user’s name and role:

```shell
doctl databases user get ca9f591d-f38h-5555-a0ef-1c02d1d1e35 example-user --format Name,Role
```

## Flags

| 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` |

## Related Commands

| Command | Description |
|---|---|
| [doctl databases user](https://docs.digitalocean.com/reference/doctl/reference/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, Default:

`--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`