Home » RDBMS Server » Security » How to reset encyption key (wallet removal) (Oracle DBServer, 11g, Windows2003)
How to reset encyption key (wallet removal) [message #404276] Thu, 21 May 2009 03:03 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 01:33:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.