It's Urgent! How To encrypt a column in Oracle8

[ko]

I want to encrypt the data in a column of one of the tables in the database. That column will contain the passwords for the users that will be using the application. Obviously a character datatype column.<br><br>I know user accounts can be created for all the users at the database level. But the requirement will not let me do that.<br><br>Please help me get out of this.<br>Best Regards

 

[MikeLacey]

So - you need a quick, fairly secure way of encrypting a passwd. As it's a passwd you don't need to decrypt it ever (you just encrupt the users attempt and compare it to the one in the database)<br><br>What platform you on? You running on a version of Unix?<br><br>As this poster is in a hurry -- If no one else has any better ideas I will suggest writing a short Perl script that returns the encrypted version of a string... Easy enough but not exactly elegant.<br><br>Comments anyone?<br> <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[ko]

Hi All<br><br>I am working on Windows NT. I am looking to find something within Oracle8 that can encrypt any type of data that I want to. <br><br>I hope Mike will come up with something other than writing a short program in Perl script.<br><br>Regards

 

[Guest_imported]

There was a thread on this on 4/29/2000, reprinted here for convenience:<br><br>&quot; Apr 17, 2000 <br>There are 2 main sql procedures that assist encryption:&nbsp;&nbsp;dbmsobtk.sql with the body contained in prvtobtk.plb and<br>dbmsoctk.sql with the body contained in prvtoctk.plb<br><br>all files are under oracle_home/rdbms/admin<br>&quot; <br><br>Hope it helps!<br>

 

[ko]

Hi All<br><br>First of all I was not been able to find the procedure prvtobtk.plb and the script dbmsobtk.sql under the directory that Mike has mentioned. Secondly I need some explanation regarding using these procedures and scripts. Remember I am using Oracle8 not Oracle8i.<br><br>Looking forward to a reply<br>Best Regards

 

[matrixdba]

You maybe trying to put to much into this. My sugguest is to use the table that your create for the users and through your application create a view on the fly that only has that user information in it at time the user execute the program and then upon closing the app drop the view or if the view is static keep it for further use in the future.<br><br>Also you have to grant create view to the user..

 

[MikeLacey]

Matrix,<br><br>Doh! That is a nice simple answer -- like it. <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[krishna77]

Hi all,
As a new member of this forum, this might look like a bit delayed follow up but hope to get a response from u guys out there..

Could you please let me know how to use these .sql & .plb files to achieve the password encryption in the table.

Also, dear matrix, could you please elaborate a bit on the solution you have provided..as a new comer to oracle programming, I couldn't follow ur solution.

Thanks in advance..

krishna