Database Security Products (MOSC)

MOSC Banner

dbms_obfuscation_toolkit.md5 -- problem upgrade from 10.2.0.3 to 10.2.0.4

edited Feb 17, 2010 6:24PM in Database Security Products (MOSC) 5 commentsAnswered
 I imported table to new 10.2.0.4 database with column that has values created by dbms_obfuscation_toolkit.md5 in 10.2.0.3. database. In 10.2.0.4 the procedure no longer matches values. Are there new requirements in 10.2.04?

Column dsu_password is defined: 

DSU_PASSWORD VARCHAR2(60 BYTE) NOT NULL,

DSU_PASSWORD VARCHAR2(60 BYTE) NOT NULL,

The following procedure returns 'Good Match' in 10.2.0.3 but returns 'Bad Match' in 10.2.0.4. Remember the table value was created in 10.2.0.3:

create or replace function dip_password(pin_username in varchar2, pin_password in varchar2) RETURN varchar2 as

    CURSOR check_cur IS SELECT * FROM dipuser.dip_system_users
      WHERE UPPER(dsu_logname) = UPPER(pin_username)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center