Home » RDBMS Server » Security » Encryption and Decryption
Encryption and Decryption [message #191183] Tue, 05 September 2006 02:18 Go to next message
ramzi_j_h
Messages: 36
Registered: September 2006
Location: Jordan
Member
Hi ... and thanx alot 4 ur cooperation in advance ...
i'm using

developer 6i
Database SQL Plus 9i


i have a table includes
student_number NOT NULL NUMBER(10)
student_password VARCHAR2(10)

as the student_number field is the username for the student,
however, when the user type his password i want to encrypt this password into the database , so

that when i log into SQL Plus i do not see the same password (encrypted or digested)
and also when i make the validation on the password when retrieving the password from the

database i want to make the decryption ...

really i read about the DBMS_OBFUSCATION_TOOLKIT

but i'm asking , is it used at the FORM LEVEL ? or DATABASE LEVEL ?

and how is it used ?

Best regards
Re: Encryption and Decryption [message #191200 is a reply to message #191183] Tue, 05 September 2006 03:01 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Quite greedy: three threads over the board. Your other copies are removed.

As DBMS_OBFUSCATION_TOOLKIT is a database package I would use it on the database. The documentation should reveal how it is used Smile

MHE
Re: Encryption and Decryption [message #191205 is a reply to message #191183] Tue, 05 September 2006 03:17 Go to previous message
ramzi_j_h
Messages: 36
Registered: September 2006
Location: Jordan
Member
it stays giving me this error while decryption !!!


ORA-28232 Invalid input size for Obfuscation toolkit

Cause: Input to DES encryption/decryption routine not a multiple of 8 bytes.

Action: Make sure that the input corresponding to the PL/SQL function is a multiple of 8 bytes.

Previous Topic: Is it possible to enable roles from after logon database trigger?
Next Topic: Copying a user
Goto Forum:
  


Current Time: Wed Dec 11 19:58:49 CST 2024