Oracle 视图 ALL_CREDENTIALS 官方解释，作用，如何使用详细说明
本站中文解释
视图
Oracle ALL_CREDENTIALS 视图显示一个用户或所有用户定义的安全凭证。
该视图显示定义的数据库用户，凭证名称，创建者，凭据的认证方法和可用的密钥信息。此视图可用于理解安全凭证的用户，以及定义他们的信息。
可以通过使用以下语句从ALL_CREDENTIALS视图显示全部安全凭据的信息：
SELECT * FROM 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 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:
-
“DBA_CREDENTIALS”
-
“USER_CREDENTIALS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_CREDENTIALpackage -
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_SCHEDULERpackage
