语法
ALTER
ENCRYPTION CERTIFICATE IDENTIFIED BY ‘old_pwd’
TO
‘new_pwd’
说明
修改密文密钥口令,old_pwd、new_pwd 均非空;
为了提高口令的安全性,可以对原证书口令进行修改,修改口令不会改变加密
密钥,只是使用新口令对原有密钥重新加密生成新证书。
gbase> alter encryption certificate identified by '1111' to '2222';
Query OK, 0 rows affected (Elapsed: 00:00:00.00)
------------旧口令解密失败
gbase> alter encryption certificate identified by '1111' to '2222';
ERROR 1829 (HY000): decrypt failed, please check password.