Oracle Wallet

-- 1. Modify SQLNET.ORA
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ENCRYPTION_WALLET_LOCATION=
	(SOURCE=(METHOD=FILE)
			(METHOD_DATA=
			(DIRECTORY=C:\oracle\product\11.2.0\win64server\NETWORK\ADMIN\)
	)
)

-- 2. Restart
-- 3. Create a wallet
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY mypassword;

-- Open
ALTER SYSTEM SET ENCRYPTION WALLET open IDENTIFIED BY mypassword;
-- Close
ALTER SYSTEM SET ENCRYPTION WALLET close IDENTIFIED BY mypassword;

-- Using encrypted column
CREATE TABLE t(c1 varchar2(32), c2 varchar2(30) encrypt);
INSERT INTO t VALUES ('Not encrypted', 'Encrypted');

tags: oracle, encryption

Last edited Jul 11, 2012 at 8:13 PM by alekseiv, version 1

Comments

No comments yet.