dbms_obfuscation_toolkit

[alison]

Hi there,

I was looking for some help on dbms_obfuscation_toolkit.

Specifically with respect to column encryption.

I was wondering if anyone has any examples of this, or could point me in the right direction.

I am running Oracle8.1.6

Many thanks

Alison

[alison]

Hi there

Sorry for answering my own thread.

I have looked through the forums and have found a thread by tomate which asks the same question.

Unfortunately I can't access metalink.oracle.com, also I was looking for a simpler example/examples to help me understand and replicate the code for my own uses.

Any help would be greatly appreciated.

Kind Regards

Alison

[hrishy]

Hi alison

i remember raeding about oracle's dbms obfuscation toolkit in oracle magazine where the advisor tom kyte has explained this.go to http://www.oracle.com/oramag search tom kytes advice on that package.


regards
hrishy

[alison]

Thanks for your reply.

I had looked through ASK TOM before I posted the question.

He does answer one like this unfortunately he just directs the guy to a technet document explaining dbms_obfuscation_toolkit.

While this is useful in understanding the concept, the example given is to encrypt single strings not entire columns (I think that's what it's doing).

I'm a novice in PL/SQL and am finding it hard recode this example.

Regards

Alison

[hrishy]

Hello ally

well you could do all of us favour here.post in your requirements here...........what exactly you want to do...............one of us from here would take the time out to translate your requirements into code.

regards
hrishy

[jlakhani]

Hello..i know that with 816 you can use dbms_obfuscation_toolkit to encrypt data but what encryption packages can i use for 8.0.5?

[sambavan]

Hope some of these would help you:

http://www-wnt.gsi.de/oragsidoc/doc_...de.htm#1021368


http://www.geocities.com/samoracle/swDataEncrypt.htm
http://www.cybcon.com/~jkstill/util/...ncryption.html
http://govt.oracle.com/~tkyte/Misc/Passwords.html <-- This you would have already come across


Sam

[alison]

Hi hrishy

My requirements are to take information in an existing table, populated with data, and run a procedure to encrypt one of the columns.

Also for all future inserts into that column to be encrypted.

For example.

create table test( name varchar2(30), password varchar2(40));

Populate it;

select * from test;
test password
---- ------------
alison oracle
andrew obvious
caroline chocolate

I would now like to encrypt the entire password column.

I understand that this is a very simple example but any sample code would be appreciated.

Many thanks

Alison

sambavan - thanks for the links they have helped me understand the theory behind the procedure

[ngwh]

do i need to run any script to install this encryption package?
doesn't mention much in the oracle websiite 8.1.6 guide....
btw how do i chk what are the packages that has been installed?

thanks.

junior

[hrishy]

Hi Ally

here is my quick (& off course dirty code ;-)

create table mytable
as select * from test
where 1=2;


CREATE OR REPLACE PROCEDURE
mod-column-name test.password%type
as
l-key Constant Number =8;
cursor c1 is select * from test;
for c1rec in c1 loop
BEGIN
--- the key and the input data must have a length
-- divisible by eight (the key must be exactly 8 bytes long).
mod-column-name := RPAD(l_string,(TRUNC(LENGTH(c1rec.password)/8)+1)*8,CHR(0));
DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT
(input_string => mod-column-name

key_string => l-key,

encrypted_string => l-encrypted-column-name);
--

--DBMS_OUTPUT.PUT_LINE('l_string ENCRYPTED: ' || l_encrypted_string);

--

--

insert into mytable values
(c1rec.user,l-encrypted-column-name);

commit;

-- Dbms_output.put_line('Encrypted data inserted');
end loop
END;

i gotta run ally as my ass is on fire today.well u can put the proceedure in a after row trigger to meet your requirements.well thanks sam i have reused the example from your site.**** ...........my boss he seems to on me i really gotta go now i am off.


regards
hrishy