Re: Changing Of Password In Oracle Application

tcox_at_usa.pipeline.com(Thomas B. Cox) wrote:

>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

You can also do it in forms 4.0 using the forms_ddl procedure. For example:

declare
  cmd varchar2(255) default 'alter user '; begin
  cmd := cmd || YourName || ' identified by ' || YourPassword;   forms_ddl( cmd );
end;

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government Received on Wed Jan 03 1996 - 00:00:00 CET