List Credentials
The PL/SQL package DBMS_CLOUD
provides the ability to store your object
storage credentials in the database using the procedure DBMS_CLOUD.CREATE_CREDENTIAL
. You can list
credentials from the view ALL_CREDENTIALS
.
For example, to list credentials, run the following command:
SELECT credential_name, username, comments FROM all_credentials;
CREDENTIAL_NAME USERNAME
---------------------------–----------------------------- --------------------
COMMENTS
---------------------------–----------------------------- --------------------
ADB_TOKEN user_name@example.com
{"comments":"Created via DBMS_CLOUD.create_credential"}
DEF_CRED_NAME user_name@example.com
{"comments":"Created via DBMS_CLOUD.create_credential"}
See ALL_CREDENTIALS for more information.