Re: Changing Oracle passwords by end users
Date: 8 Dec 1994 10:53:56 GMT
Message-ID: <3c6ok5$fe_at_bock.freinet.de>
> Hello world,
>
> has anybody ever tried to do the following for changing the Oracle password:
> - Let the user enter the old password en the new password twice.
> - The program should check the old password (to prevent a joker from
> changing the password on a deserted workstation)
> - The program should check if the two new entries are equal
> - The program should alter the password.
>
> Setup:
> Forms 3.0, Menu 5.0, Plus 3.1 on MS-DOS clients, Oracle 7.0 (on RS-6000).
We've just been working on this problem:
Our setup:
Forms 4.0.12, Oracle 7.1 on HP 9000
Forms 4.0.12 allows dynamic sql via 'forms_dll'
e.g.: forms_dll('alter user john identified by scott_tiger');
Important: no ';' at the end of the string!
/* Btw: if you create dynamic DML-stmts you have to put them in a
'begin'-'end' bracket.
*/
Does anybody know how to retrieve the old password ?
Peter Wazinski Received on Thu Dec 08 1994 - 11:53:56 CET