Wallet for Tablespace and table data secure in Oracle

Wallet for Tablespace and table data secure in Oracle

Steps to Configured the wallet

1. Make entry into the sqlnet.ora file

ENCRYPTION_WALLET_LOCATION=
(SOURCE=(METHOD=FILE)(METHOD_DATA=
(DIRECTORY=E:\oracle\Encrypt_Wallet)))

2. Run the following command it will automatically create wallet

-- 10g version
sqlplus / as sysdba
ALTER SYSTEM SET ENCRYPTION KEY AUTHENTICATED BY "Password";

-- 11g version
sqlplus / as sysdba
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "password";

3. Login with sqlplus Check any wallet is configured and status is open/closed:

select * from v$ENCRYPTION_WALLET;

4. Close the system wallet

ALTER SYSTEM SET ENCRYPTION WALLET CLOSE;

ORA-28390: auto login wallet not open but encryption wallet may be open

alter system set encryption wallet close identified by "password"

5. Open the system wallet

ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "password";

6. Modify the existing table column to wallet encryption

ALTER TABLE IC.TEST MODIFY (salary ENCRYPT);

7. Check the tables present with encrypted columns:

SET LINESIZE 100
COLUMN owner FORMAT A15
COLUMN tble_name FORMAT A15
COLUMN column_name FORMAT A15
SELECT * FROM dba_encrypted_columns;

8. You can also create tablespace for encryption but you need to create it new and move the object to it.

SELECT tablespace_name, encrypted FROM dba_tablespaces;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s