doctl databases user get
Generated on 9 Apr 2025
from doctl version
v1.124.0
Usage
doctl databases user get <database-cluster-id> <user-name> [flags]Aliases
gDescription
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:
doctl databases user get ca9f591d-f38h-5555-a0ef-1c02d1d1e35 example-user --format Name,RoleFlags
| 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 | 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 |