Manage database accounts

Create an application accountCopy Anchor Link

1. Open the database detail page and find Database accounts.
2. Enter an Account name, such as app_backend.
3. Select Add account and wait for the operation to finish.
4. Select the active account under Connection account, then choose Load connection details.
5. Update the application configuration with the generated credentials and verify a new connection.

Names must start with app_, followed by 1–55 lowercase letters, numbers, or underscores. Passwords are generated automatically.

Application accounts can connect and work with objects in the public schema without server-administrator privileges. Ownership and grants between application accounts remain PostgreSQL-managed; creating an account does not make it the owner of every existing object.

Rotate an application passwordCopy Anchor Link

1. Select Rotate password for an active application account.
2. Confirm with Generate new password.
3. After completion, load the new connection credentials.
4. Update application secrets and reconnect clients.

The username stays the same. Existing sessions are not disconnected by rotation, so test a new connection to verify the replacement password.

If the Console reports an interrupted update, the database password might already have changed. Check operation status and reload credentials before retrying; do not assume the old password remains valid.

The Console does not expose password rotation for the initial administrator or deletion of application accounts.