Re: Changing user password from Oracle Forms.

I have a bulletin from Oracle that explains how to change a user's password. It does it through a form but the following syntax may resolve your problem.

The password change is achieved by issuing a forms_ddl command:

FORMS_DDL('ALTER user '|| UN || ' IDENTIFIED BY ' || PW);

Hope this helps.

Kathie

Amir Raza Khan wrote in article <5pb319$ks_at_drn.zippo.com>...
>
> Is there any body on this planet to HELLLLLLLLP me.
>
> Here is my problem.
>
> I am working in D2K, while using Oralce Forms 4.5 I have retrived the
 user
> password with GET_APPLICATION_PROPERTY but I am unable to change it.
> SET_APPLICATION_PROPERTY can not set the password of the user and
> 'ALTER USER ...' command can not be used because it gives following error
 at
> compile time.
> Encountered the symbol 'ALTER' which is an unsupported reserved word.
>
> I will be very gratful if any body can answer. THANKS.
>
>
> Amir Raza Khan (SE)
> Lahore Stock Exchange
>
> arkhan_at_genius.brain.net.pk
> sems_at_brain.net.pk
>
Received on Tue Jul 08 1997 - 00:00:00 CEST