OraFAQ Forum: Security

Home » RDBMS Server » Security » Encryption

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

Encryption [message #229036]

Thu, 05 April 2007 02:41

kamalpriya
Messages: 3
Registered: April 2007

Junior Member

Hi,

How to do a table level and column level encryption and decryption in oracle9i database.

Thanks

Report message to a moderator

Re: Encryption [message #229048 is a reply to message #229036]

Thu, 05 April 2007 03:19

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

Senior Member
Account Moderator

Use dbms_obfuscation_toolkit package.
There is no built-in feature in 9i like TDE in 10g.

Regards
Michel

Report message to a moderator

Re: Encryption [message #229060 is a reply to message #229048]

Thu, 05 April 2007 04:17

kamalpriya
Messages: 3
Registered: April 2007

Junior Member

Hi,

Thanks for your update.

Please let me know is it possible to a column-level and table level encryption using this tool-kit.

thanks

Report message to a moderator

Re: Encryption [message #229068 is a reply to message #229060]

Thu, 05 April 2007 04:33

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

Senior Member
Account Moderator

I thought this is what I said.

Report message to a moderator

Re: Encryption [message #229074 is a reply to message #229068]

Thu, 05 April 2007 04:50

kamalpriya
Messages: 3
Registered: April 2007

Junior Member

I have checked that link. But I didnt find much about the table-level and column-level. It's all about a single string.

Please give me a steps in details for that if you any.

Thanks

Report message to a moderator

Re: Encryption [message #229077 is a reply to message #229074]

Thu, 05 April 2007 05:02

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

Senior Member
Account Moderator

Yes you have to manually encrypt and decrypt your data.
As I previously said, there is no built-in feature in 9i.
You have to do it yourself.

Regards
Michel

Report message to a moderator

Previous Topic:	Deleting a User entry from OID using dbms_ldap
Next Topic:	dbms_ldap error Password Policy Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 06 20:05:44 CDT 2026