Update Vault Secret Credentials

Describes the steps to update vault secret credential attributes.

To update vault secret credential attributes:

  1. Use DBMS_CLOUD.UPDATE_CREDENTIAL to update a vault secret credential attribute.

    For example:

    BEGIN DBMS_CLOUD.UPDATE_CREDENTIAL(
        credential_name   => 'VAULT_SECRET_CRED',
        attribute         => 'secret_id',
        value             => 'new_secret_id'
      );
    END;
    /

    To update a vault secret credential you must have EXECUTE privilege on the DBMS_CLOUD package.

    See UPDATE_CREDENTIAL Procedure for more information.

  2. Use the updated credential to access a cloud resource.

    For example:

    SELECT count(*) FROM DBMS_CLOUD.LIST_OBJECTS(
        'VAULT_SECRET_CRED',
        'https://objectstorage.us-phoenix-1.oraclecloud.com/n/namespace-string/b/bucketname/o/' );