人大金仓V8R6数据库表空间加密

1、修改kingbase.conf参数文件

shared_preload_libraries = sysencrypt

2、打开wallet

alter WALLET WITH PASSWORD "123456";

OPENUP WALLET WITH PASSWORD "123456";

3、创建表空间目录[kingbase@B140 V8]$ cd encrypt_tsp/

4、创建加密表空间

CREATE TABLESPACE encrypt_tsp LOCATION '/home/kingbase/KingbaseES/V8/encrypt_tsp' with (encryption = true,enckey = '123456abc');

5、创建加密表

create table encrypt_test(id int,name varchar2(100)) tablespace encrypt_tsp;

insert into encrypt_test values(1,'aaaaaaaaaa');

insert into encrypt_test values(2,'aaaaaaaaaa');

insert into encrypt_test values(3,'aaaaaaaaaa');

--6、查看加密表数据文件

select sys_relation_filepath('ENCRYPT_TEST');

strings datafile

--7、创建普通表

create table test(id int,name varchar2(100));

insert into test values(1,'aaaaaaaaaa');

insert into test values(2,'aaaaaaaaaa');

insert into test values(3,'aaaaaaaaaa');

--8、查看普通表数据文件

select sys_relation_filepath('TEST');

strings datafile