Re: Password change

In article <36C933F5.124B_at_bhp.com.au>,   Connor McDonald <mcdonald.connor.cs_at_bhp.com.au> wrote:
> murphy_sp_at_jpso.com wrote:
> >
> > Does anyone know of a way to change a password on Oracle 7.3xxx from an
> > application created in Dev (2.1) Forms 50?
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
> Sorry - you got to write your own...
>
> Pretty easy though - window with "old password" and "new password" and
> "verify new password" text items, then issue
>
> forms_ddl('alter user '||:user||' identified by '||:newpass);
>
> HTH
> --
> ==============================================
> Connor McDonald
> BHP Information Technology
> Perth, Western Australia
> "Never wrestle a pig - you both get dirty and the pig likes it..."
>

Alternatively, you could use the same new password Form and pass the username and new password as parameters to a stored procedure that uses the DBMS_SQL package. Often there is a slight performance advantage to using compiled server-side code, but I doubt that there is any significant advantage in this case. For the specifics on how to use DBMS_SQL for the purpose of changing passwords, search past posts on this forum.

Cheers,
Cary

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 17 1999 - 23:00:27 CET