Note
This view is available starting with V4.3.0.
Purpose
The DBA_OB_TRUSTED_ROOT_CERTIFICATE view displays the list of CA root certificates trusted by the OBServer cluster and related information such as the expiration time of the certificates.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| COMMON_NAME | varchar(256) | NO | The common name of the certificate. |
| DESCRIPTION | varchar(256) | NO | The source and purpose of the certificate. |
| CERT_EXPIRED_TIME | timestamp(6) | NO | The expiration time of the certificate. |
Sample query
Query the list of CA root certificates trusted by the OBServer cluster and related information such as the expiration time of the certificates.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE;