Home » RDBMS Server » Security » encryption key management (Oracle 9i)
encryption key management [message #280704] Wed, 14 November 2007 10:10 Go to next message
anantha_d
Messages: 2
Registered: November 2007
Junior Member
Hi,

Can anyone please help me in security key management for encryption and decryption.

I have a scenario like below:

I need to create a package with encryption key, generated by oracle and need to wrap the package. But this has to be done dynamically. (The key cannot be visible to anybody).

Can anybody please give me some ideas about this?

Thanks,
Anantha
Re: encryption key management [message #280726 is a reply to message #280704] Wed, 14 November 2007 10:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Wrap is not encryption and before 10g if your encryption key is a string it will be in clear after wrapping.

In 10g, you can dynamically create a wrap package using dbms_ddl.create_wrapped.

Regards
Michel
Re: encryption key management [message #280791 is a reply to message #280704] Wed, 14 November 2007 14:16 Go to previous messageGo to next message
anantha_d
Messages: 2
Registered: November 2007
Junior Member
Thanks for your reply Michel. I am so sorry, forgot to mention that I am using oracle db version 9. I have to do the below steps:

1. generate a key
2. create (or recreate) a package with that generated key
3. wrap the package.

I have to do the above things dynamically without any user interaction.

Please let me know if you have any idea on this.

Thanks,
Anantha
Re: encryption key management [message #280795 is a reply to message #280791] Wed, 14 November 2007 14:24 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In 9i, you have to use wrap utility.
Search for "executing an OS command in PL/SQL" (or the like) on AskTom.

Regards
Michel
Previous Topic: Grant TableSpace.?
Next Topic: retrive database user password
Goto Forum:
  


Current Time: Thu Mar 28 07:52:11 CDT 2024