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 certificate expiration time.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| COMMON_NAME | varchar(256) | NO | The common name of the certificate. |
| DESCRIPTION | varchar(256) | NO | The description of the certificate source and purpose. |
| 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 certificate expiration time.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE;