Update Vault Secret Credentials
Describes the steps to update vault secret credential attributes.
To update vault secret credential attributes:
-
Use
DBMS_CLOUD.UPDATE_CREDENTIALto 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
EXECUTEprivilege on theDBMS_CLOUDpackage.See UPDATE_CREDENTIAL Procedure for more information.
-
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/' );