OraFAQ Forum: Security » How to reset encyption key (wallet removal)

Home » RDBMS Server » Security » How to reset encyption key (wallet removal) (Oracle DBServer, 11g, Windows2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to reset encyption key (wallet removal) [message #404276]

Thu, 21 May 2009 03:03

vincent.rodriguez
Messages: 1
Registered: May 2009

Junior Member

Hi All,

Does anybody know how one can "unset" a previuosly defined encryption key?

The key was originally created with the following command:
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "password"

The wallet file was properly created under %ORACLE_BASE%/admin/%ORACLE_SID%/wallet directory.

I can now easily remove the wallet file, but have no idea how to get rid of the entry in the v$encryption_wallet view.

The
"ALTER SYSTEM RESET ENCRYPTION KEY" doesn't seem to work.

Any idea?
Thanks,
Vincent

Report message to a moderator

Re: How to reset encyption key (wallet removal) [message #407718 is a reply to message #404276]

Thu, 11 June 2009 04:56

brillix
Messages: 6
Registered: June 2009

Junior Member

Actually you can't remove the entry from - v$encryption_wallet

Just recreate the wallet and set a new encryption key.

Oracle can only use one wallet at a time and v$encryption_wallet specify the location of the wallet nothing else.

Oded

Report message to a moderator

Previous Topic:	data masking on xml columns
Next Topic:	User details - 3 tier application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 09:15:54 CDT 2025