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. On the Database systems list page, select the database system that you want to work with. If you need help finding the list page or the database system, see Listing Database Systems.
    2. On the database system details page, select More actions and then select Reset administrator credentials.
    3. 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.
    4. 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.