Note
This view is introduced since OceanBase Database V4.3.0.
Purpose
The DBA_OB_TRUSTED_ROOT_CERTIFICATE view displays the list of trusted root CA certificates of the current OceanBase cluster, as well 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
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE;