Oracle: Is there a way to encode a value using the unix crypt method?

Question

Is there a way to encode a value using the unix crypt method in oracle 10g?

Adam Musch · Answer 1 · 2011-05-03T14:48:36.050

3

The DBMS_CRYPTO PL/SQL package has encryption, but none using the native weakness of the Unix crypt(1). It's much more analogous to crypt(3).

If you need the exact crypt(1) implementation, you're going to have to code it yourself. Here's the C code for it.

edited May 03 '11 at 14:48

answered May 03 '11 at 13:59

Adam Musch

13,286
2
28
32

Unfortunately, I need the exact crypt encoding. – MRalwasser May 03 '11 at 14:23

score 2 · Accepted Answer · answered May 03 '11 at 18:32

2

Provided you are one Oracle8i or higher this is possible.

The solution is to write a Java Stored Procedure which can execute OS commands, and use that to run Unix crypt. Tim Hall's Oracle-Base site has an example of how to code one of these things. Find it here.

answered May 03 '11 at 18:32

APC

144,005
19
170
281

Hope he's not on windows; if so, he's going to have to install POSIX to boot. – Adam Musch May 04 '11 at 04:18
I'm not on windows, but unfortunately this is not an option for me. anyway, i'll accept the answer. Thanks – MRalwasser May 25 '11 at 21:19

Oracle: Is there a way to encode a value using the unix crypt method?

2 Answers2