ALL_CREDENTIALS
ALL_CREDENTIALS lists all credentials visible to the user.
Related Views
-
DBA_CREDENTIALSlists all credentials in the database. -
USER_CREDENTIALSlists credentials owned by the current user. This view does not display theOWNERcolumn.
| 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(32767) |
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.
See Also:
-
Oracle AI Database PL/SQL Packages and Types Reference for more information about the
DBMS_CREDENTIALpackage -
Oracle AI Database PL/SQL Packages and Types Reference for more information about the
DBMS_SCHEDULERpackage