检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Security Functions Security Functions gs_encrypt_aes128(encryptstr,keystr) Description: Encrypts encryptstr strings using keystr as the key and returns encrypted strings.
Security Functions Security Functions gs_encrypt_aes128(encryptstr,keystr) Description: Encrypts encryptstr strings using the key derived from keystr and returns encrypted strings.
Security Functions Security Functions gs_encrypt_aes128(encryptstr,keystr) Description: Encrypts encryptstr strings using the key derived from keystr and returns encrypted strings.
Kernel Error Information ERRMSG: "unsupported syntax: ENCRYPTED WITH in this operation" SQLSTATE: 42601 CAUSE: "client encryption feature is not supported this operation." ACTION: "Check client encryption feature whether supported this operation."
Kernel Error Information ERRMSG: "unsupported syntax: ENCRYPTED WITH in this operation" SQLSTATE: 42601 CAUSE: "client encryption feature is not supported this operation." ACTION: "Check client encryption feature whether supported this operation."
Kernel Error Information ERRMSG: "unsupported syntax: ENCRYPTED WITH in this operation" SQLSTATE: 42601 CAUSE: "client encryption feature is not supported this operation." ACTION: "Check client encryption feature whether supported this operation."
Kernel Error Information ERRMSG: "unsupported syntax: ENCRYPTED WITH in this operation" SQLSTATE: 42601 CAUSE: "client encryption feature is not supported this operation." ACTION: "Check client encryption feature whether supported this operation."
Actually, encrypted columns that depend on CEKs cannot be deleted. Examples 1 2 3 4 -- Delete a CEK object. gaussdb=# DROP COLUMN ENCRYPTION KEY ImgCEK CASCADE; ERROR: cannot drop column setting: imgcek cascadely because encrypted column depend on it.
Actually, encrypted columns that depend on CEKs cannot be deleted. Examples 1 2 3 4 -- Delete a CEK. gaussdb=# DROP COLUMN ENCRYPTION KEY ImgCEK CASCADE; ERROR: cannot drop column setting: imgcek cascadely because encrypted column depend on it.
Set this parameter to on before creating an encrypted table. If this parameter is set to off, new encrypted tables cannot be created. The created encrypted table is decrypted only when data is read and is not encrypted when the data is written.
Set this parameter to on before creating an encrypted table. If this parameter is set to off, new encrypted tables cannot be created. The created encrypted table is decrypted only when data is read and is not encrypted when the data is written.
When you create a foreign table, the AK value is encrypted and saved to the metadata table of the database.
When you create a foreign table, the AK value is encrypted and saved to the metadata table of the database.
When you create a foreign table, the AK value is encrypted and saved to the metadata table of the database.
When you create a foreign table, the AK value is encrypted and saved to the metadata table of the database.
Examples 1 2 3 4 -- Delete a CEK. openGauss=# DROP COLUMN ENCRYPTION KEY ImgCEK CASCADE; ERROR: cannot drop column setting: imgcek cascadely because encrypted column depend on it. HINT: we have to drop encrypted column: name, ... before drop column setting: imgcek cascadely.
HINT: we have to drop encrypted column: name, ... before drop column setting: imgcek cascadely. Parent topic: SQL Syntax
Setting suggestion: If indexes of all encrypted tables need to be encrypted, enable this parameter. You do not need to manually set indexes to encrypted indexes.
Setting suggestion: If indexes of all encrypted tables need to be encrypted, enable this parameter. You do not need to manually set indexes to encrypted indexes.
If the encryption type of the encrypted column is specified as random encryption, the column type is BYTEAWITHOUTORDERCOL). The original data type is displayed when the encrypted table is printed by running the meta command. 4 bytes plus the actual binary string.