Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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(30) 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(30) 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(30) 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