开启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;
标签:插件,加密,Kingbase,sys,单表,test,table,kdb
From: https://www.cnblogs.com/guosk/p/18243317