Oracle Cloud Infrastructure Documentation

Resetting the Administrator Credentials for a Database System

Learn how to change the administrator credentials for an OCI Database with PostgreSQL database system.

Note

You can change the password of the administrator, but you can't change the username.

Administrators don't get superuser access. An OCI Database with PostgreSQL admin user can create users and roles.

    1. Open the navigation menu and click Databases. Under PostgreSQL, click DB Systems.
    2. (Optional) In the List scope section, under Compartment, select a compartment.
    3. Click the name of the database system that you want to edit.
    4. On the DBSystem details page, click More actions and choose Reset administrator credentials.
    5. In the Reset administrator credentials panel, choose how to update the password:
      • Input password:
        • Password: Specify the new administrator password.
        • Confirm password: Confirm the new administrator password.
      • Use OCI Vault:
        • Vault: Select the vault that contains the new administrator password.
        • Secret: Select the secret containing the new administrator password.
        • Secret version: Select a secret version.
    6. Click Reset.

  • Use the oci psql db-system reset-master-user-password, oci psql db-system reset-master-user-password-plain-text-password-details, or oci psql db-system reset-master-user-password-vault-secret-password-details command and required parameters to reset passwords:

    oci psql db-system reset-master-user-password --db-system-id <db_system_OCID> --password-details <file://password-details.json> [OPTIONS]
    oci psql db-system reset-master-user-password-plain-text-password-details --db-system-id <db_system_OCID> --password-details-password <example-password> [OPTIONS]
    oci psql db-system reset-master-user-password-vault-secret-password-details --db-system-id <db_system_OCID> --password-details-secret-id <secret_OCID> --password-details-secret-version <secret_version> [OPTIONS]

    For a complete list of parameters and values for CLI commands, see the CLI Command Reference.

  • Run the ResetMasterUserPassword operation to reset the master password credentials for the database.

    For information about using the API and signing requests, see REST API documentation and Security Credentials. For information about SDKs, see SDKs and the CLI.