SQLPlus Command Line - Is There A Way to Encrypt the Password ? 1

[ihda]

The Oracle login name and password are in plain text. Can the password be encrypted?

Thank you.

 

[HimanB]

Hi,
You may make use of dbms_obfuscation_toolkit package.

For sample code refer to Note:102902.1 at metalink.

HTH
regards
Himanshu

 

[ihda]

Thank you for the feedback.
The dbms_obfuscation_toolkit package works fine....is there a way, in memory, to pass the decrypted password directly to a connect command?

Thanks.

 

[Kido]

Try this code:

FUNCTION Ini_pass_decrypt RETURN varchar2 IS
v_length number(20);
v_check number(20) := 1;
v_decrypt varchar2(1);
v_asc_decrypt number(3);
v_dbpwdencrypt varchar2(20);

BEGIN
v_length := NVL(lengthglobal.dbpwdencrypt),0);

WHILE v_length + 1 > v_check LOOP

v_asc_decrypt := ASCII(SUBSTRglobal.dbpwdencrypt,v_check,1));

IF v_asc_decrypt >= 97 THEN
v_asc_decrypt := v_asc_decrypt - 64;
ELSE
v_asc_decrypt := v_asc_decrypt + 31;
END IF;

v_decrypt := CHR(v_asc_decrypt);
v_dbpwdencrypt := v_dbpwdencrypt || v_decrypt;

v_check := v_check + 1;

END LOOP;

:global.dbpwdencrypt := v_dbpwdencrypt;
Return 0;

END;