ALL_CREDENTIALS

2.89 ALL_CREDENTIALS

ALL_CREDENTIALS lists all credentials visible to the user.

Related Views

DBA_CREDENTIALS lists all credentials in the database.
USER_CREDENTIALS lists credentials owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the credential
`CREDENTIAL_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the credential
`USERNAME`	`VARCHAR2(128)`		Name of the user that will be used to log in to the remote database or the remote or local operating system
`WINDOWS_DOMAIN`	`VARCHAR2(30)`		For a Windows target, the Windows domain to use when logging in
`COMMENTS`	`VARCHAR2(4000)`		Comments on the credential
`ENABLED`	`VARCHAR2(5)`		Indicates whether this credential is enabled (`TRUE`) or not (`FALSE`)

Note:

DBMS_CREDENTIAL lists credentials that can be used to run external procedures, or by DBMS_SCHEDULER for remote or external jobs, or for storing or retrieving files from the operating system.

If a credential is disabled, then any of the actions above that attempts to use the credential will fail.