2.90 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(240)

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.

See Also: