更新日期:2024年09月11日
语法
明文密钥转换为密文密钥:
ALTER
ENCRYPTION
CERTIFICATE IDENTIFIED BY ‘’ TO ‘password’
密文密钥转换为明文密钥:
ALTER
ENCRYPTION
CERTIFICATE IDENTIFIED BY
’ password’
TO
‘’
说明
明文密钥转换为密文密钥,password 不能为空;
明文加密转换为密文加密,即通过口令将明文密钥加密作为密文密钥证书,数据加
密所用密钥不变。
密文密钥转换为明文密钥,password 不能为空;密文密钥转换为明文密钥,即通过
口令将密文密钥解密获取到的密钥作为明文密钥,数据加密所用密钥不变;
-----------明文密钥转密文密钥
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
451
gbase> alter encryption certificate identified by ‘’ to ‘2222’;
Query OK, 0 rows affected
-----------证书不存在
gbase> alter encryption certificate identified by ‘’ to ‘2222’;
ERROR 1850 (HY000): this syntax is unsupported with current encrypt type
-----------密文密钥转明文密钥
gbase> alter encryption certificate identified by 'ddd22' to ‘’;
Query OK, 0 rows affected
-----------证书不存在
gbase> alter encryption certificate identified by 'ddd22' to ‘’;
ERROR 1850 (HY000): this syntax is unsupported with current encrypt type