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

CLIENT

VARCHAR2(2000)

Name provided by the client

SECRET_TAG

VARCHAR2(4000)

Associated information with the client

CREATION_TIME

TIMESTAMP(6) WITH TIME ZONE

Time when the secret was created

ACTIVATION_TIME

TIMESTAMP(6) WITH TIME ZONE

Time when the secret was actually put to use

OWNER

VARCHAR2(128)

User who created the secret

OWNER_ID

NUMBER

User ID of the user who created the secret

KEYSTORE_TYPE

VARCHAR2(17)

Secret is in Hardware Security Module (HSM) or Software Key Store

BACKED_UP

VARCHAR2(9)

Indicates whether the secret has been backed up or not

OWNER_DBNAME

VARCHAR2(128)

Database that created the secret

OWNER_DBID

NUMBER

Database ID where the secret was created

OWNER_INSTANCE_NAME

VARCHAR2(30)

Instance name of the instance where the secret was created

OWNER_INSTANCE_NUMBER

NUMBER

Instance number of the instance where the secret was created

OWNER_INSTANCE_SERIAL

NUMBER

Serial number of the instance where the secret was created

OWNER_PDBNAME

VARCHAR2(128)

Pluggable database (PDB) where the secret was created

OWNER_PDBID

NUMBER

PDB ID where the secret was created

OWNER_PDBUID

NUMBER

PDB UID where the secret was created

OWNER_PDBGUID

RAW(16)

PDB GUID where the secret was created

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also:

Oracle Database Advanced
Security Guide
for information about keystore management


数据运维技术 » Oracle 视图 V$CLIENT_SECRETS 官方解释,作用,如何使用详细说明