|
-
U need some mathematical function(s), that has:
-- direct conversion from open password to enscripted
-- revert conversion from enscripted password to open
On asktom.oracle.com u can get 1 way conversion
function, that using hash function to create enscripted password :
ops$tkyte@8i> declare
2 function digest( p_username in varchar2, p_password in varchar2 )
return varchar2
3 is
4 begin
5 return ltrim( to_char( dbms_utility.get_hash_value(
upper(p_username)||'/'||upper(p_password),
6 1000000000,
power(2,30) ),
7 rpad( 'X',29,'X')||'X' ) );
8 end digest;
9 begin
10 for x in ( select username from all_users where rownum < 20 )
11 loop
12 dbms_output.put_line( 'User: ' || rpad( x.username , 30 ) ||
13 ' digest: ' || digest( x.username, 'TIGER' )
);
14 end loop;
15 end;
16 /
-----------------------------------------------------------------------
But in ur case this function doesn't work.
U need 2-way transformation some like "long gamma with marcant group".
I don't thing, that u can find it on pl/sql so easy.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|