Oracle Cloud Infrastructure Documentation

Managing the Administrator Credentials for a Database System

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

When you create a database system, you set the database system administrator credentials. Administrators don't get superuser access, but they do get assigned an oci_admin_role. An OCI Database with PostgreSQL admin user can create users and roles and enable certain extensions.

Note

You can change the password of the administrator, but you can't change the username.
    1. Open the navigation menu and select Databases. Under PostgreSQL, select DB Systems.
    2. (Optional) In the List scope section, under Compartment, select a compartment.
    3. Select the database system that you want to edit.
    4. On the database system details page, select More actions and then select 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. Select 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.