Oracle Cloud Infrastructure Documentation

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/' );