Oracle 视图 V$CLIENT_SECRETS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle 视图 V$CLIENT_SECRETS 是 Oracle 软件内部视图,用于解析维护和客户端身份验证秘密。它被用于表示客户端身份验证秘密,如用户名/口令,身份令牌和为客户端连接提供的秘密,这些秘密是由客户端所在的环境以及使用的协议来维护的,这可能是ODBC,JDBC,OCI,高级网络服务或高级安全服务。
在使用 V$CLIENT_SECRETS 视图时,只有DBA级别的用户可以访问其中的数据。 DBA可以使用该视图来检查客户端到数据库服务器的连接是否安全,并检查客户端应用代码是否正确使用身份验证秘密。此外,DBA还可以使用该视图来删除已过期的客户端身份验证秘密,以确保安全性。
官方英文解释
V$CLIENT_SECRETS
lists the secrets that are present in the keystore.
Only SYS
, SYSKM
, and users with the ADMINISTER KEY MANAGEMENT
privilege can access this view.
Column | Datatype | Description |
---|---|---|
|
|
Name provided by the client |
|
|
Associated information with the client |
|
|
Time when the secret was created |
|
|
Time when the secret was actually put to use |
|
|
User who created the secret |
|
|
User ID of the user who created the secret |
|
|
Secret is in Hardware Security Module (HSM) or Software Key Store |
|
|
Indicates whether the secret has been backed up or not |
|
|
Database that created the secret |
|
|
Database ID where the secret was created |
|
|
Instance name of the instance where the secret was created |
|
|
Instance number of the instance where the secret was created |
|
|
Serial number of the instance where the secret was created |
|
|
Pluggable database (PDB) where the secret was created |
|
|
PDB ID where the secret was created |
|
|
PDB UID where the secret was created |
|
|
PDB GUID where the secret was created |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
Oracle Database Advanced
Security Guide for information about keystore management