Re: Changing Of Password In Oracle Application

On Dec 23, 1995 05:02:22 in article <Changing Of Password In Oracle Application>, 'mcblohkc_at_leonis.nus.sg (Loh Kir Chern)' wrote:    

>We developed a MIS application using Forms 4.0.13.20.0, is there anyway
>that we can build a friendly and convenient way for users to change their
 

>password in the application, besides having to exit the application and
>going via sqlplus, teaching them "alter user .... identified by ... "? It
 

>should be GUI, password would not be echoed when typing etc. Does anyone
>have such experience ?
 

Our solution, using Forms 4.0.x at the time, was to use a Forms front end to gather the data (old password, new password twice, not echoed), do some verification, and then call SQL*Plus in silent mode to perform the actual change.  

I believe you can now do pretty much any valid SQL statement, including password changes, using built-in packages such as DBMS_SQL (if I have that name correct...) as of Oracle 7.1 or later.  

-- 
 
Thomas B. Cox