Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


ALL_CREDENTIALS lists all credentials visible to the user.

Related Views

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(240)   Comments on the credential
ENABLED VARCHAR2(5)   Indicates whether this credential is enabled (TRUE) or not (FALSE)


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.

See Also: