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 theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the credential |
|
|
|
Name of the credential |
|
|
|
Name of the user that will be used to log in to the remote database or the remote or local operating system |
|
|
|
For a Windows target, the Windows domain to use when logging in |
|
|
|
Comments on the credential |
|
|
|
Indicates whether this credential is enabled ( |
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 Database PL/SQL Packages and Types Reference for more information about the
DBMS_CREDENTIAL
package -
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_SCHEDULER
package