OraFAQ Forum: Security » encryption key management

Home » RDBMS Server » Security » encryption key management (Oracle 9i)

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

encryption key management [message #280704]

Wed, 14 November 2007 10:10

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

Report message to a moderator

Re: encryption key management [message #280726 is a reply to message #280704]

Wed, 14 November 2007 10:41

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: encryption key management [message #280791 is a reply to message #280704]

Wed, 14 November 2007 14:16

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

Report message to a moderator

Re: encryption key management [message #280795 is a reply to message #280791]

Wed, 14 November 2007 14:24

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Grant TableSpace.?
Next Topic:	retrive database user password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 11:40:22 CDT 2025