oracle 11g wallet configure
cat $ORACLE_HOME/network/admin/sqlnet.ora
ENCRYPTION_WALLET_LOCATION =
(SOURCE = (METHOD = FILE)
(METHOD_DATA = (DIRECTORY=/u01/product/oracle/11.2.0/db_1/network/admin/wallet)
)
(SOURCE = (METHOD = FILE)
(METHOD_DATA = (DIRECTORY=/u01/product/oracle/11.2.0/db_1/network/admin/wallet)
)
SQL> alter system set key identified by "welcome";
System altered.
open wallet
SQL> alter system set wallet open identified by "welcome";
System altered.
close wallet
SQL> alter system set wallet close identified by "welcome";
System altered.
create table test_wallet (id number,credit_card_number varchar2(16) ENCRYPT NO SALT);
insert into test_wallet values(1,'1231243242');
insert into test_wallet values(2,'33245235');
commit;
insert into test_wallet values(2,'33245235');
commit;
加密列
alter table test_wallet modify (id encrypt);
alter table test_wallet modify (id encrypt);
去掉加密列
alter table test_wallet modify (id decrypt);
alter table test_wallet modify (id decrypt);
更改加密算法
alter table test_wallet rekey using 'aes256';
alter table test_wallet rekey using 'aes256';
如果考虑ID列使用索引，则
alter table test modify (id encrypt no salt);
alter table test modify (id encrypt no salt);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25198367/viewspace-714319/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
LINUX 设置SSH限制IP登入
下一篇：
审核数据库DDL操作记录实现
请登录后发表评论
登录
全部评论
