Kingbase单表加密

开启Kingbase的加密插件

修改kingbase.conf, 找到shared_preload_libraries配置项，增加sysencrypt插件，多个插件用半角逗号隔开。

• 示例：

shared_preload_libraries = 'liboracle_parser, synonym, plsql, force_view, kdb_flashback,plugin_debugger, plsql_plugin_debugger, plsql_plprofiler, kdb_ora_expr, sepapower, dblink, sys_kwr, sys_spacequota, sys_stat_statements, backtrace, kdb_utils_function, auto_bmr, sys_squeeze, src_restrict, sysencrypt'

重启金仓

docker restart kingbase

创建测试表

create table test_table
(
    id         int4(10) not null
        constraint id
        primary key,
    text_field varchar(255),
    date_field date(29)
);

加密该表

密码为qwer1234

ALTER TABLE test_table ENCRYPTED by 'qwer1234';

取消表加密

ALTER TABLE test_table NOT ENCRYPTED;