Overview
Displays the encryption status of tables with encryption enabled under the current tenant.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | Tenant ID |
| TABLE_ID | bigint(20) | NO | Table ID |
| TABLE_NAME | varchar(256) | NO | Table name |
| TABLESPACE_ID | bigint(20) | NO | Tablespace ID |
| ENCRYPTIONALG | varchar(30) | NO | Encryption algorithm name:
|
| ENCRYPTED | varchar(3) | NO | Encryption completed:
|
| ENCRYPTEDKEY | varchar(33) | NO | Encrypted Key Encrypted by Primary Key |
| MASTERKEYID | bigint(20) unsigned | NO | Primary Key Version |
| BLOCKS_ENCRYPTED | decimal(20,0) | NO | Number of Encryption Macroblocks |
| BLOCKS_DECRYPTED | decimal(21,0) | NO | Number of Uncrypted Macroblocks |
| STATUS | varchar(10) | NO | Encryption status:
|
| CON_ID | bigint(20) | NO | Tenant ID |
Sample query
Check the encryption status of tables with encryption enabled under the current tenant.
obclient [oceanbase]> SELECT TABLE_NAME, ENCRYPTIONALG, ENCRYPTED FROM oceanbase.V$OB_ENCRYPTED_TABLES;
The query result is as follows:
+------------+---------------+-----------+
| TABLE_NAME | ENCRYPTIONALG | ENCRYPTED |
+------------+---------------+-----------+
| t1 | aes-256 | YES |
+------------+---------------+-----------+
1 row in set
References
For more information about data transparent encryption, see Overview of database transparent encryption.