7.122 V$CLIENT_SECRETS

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