Re: Changing user password from Oracle Forms.
From: R. Fingerson <rfinger_at_netmail.mnet.uswest.com>
Date: 1997/07/02
Message-ID: <33BA8350.10E0_at_netmail.mnet.uswest.com>#1/1
Date: 1997/07/02
Message-ID: <33BA8350.10E0_at_netmail.mnet.uswest.com>#1/1
Amir, Raza, Khan wrote:
>
> 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.
You should be able to use the dbms_sql package to do this, and build the 'alter user' statement as a character string.
Robin
-- phouka_at_frii.com http://www.frii.com/~phouka/ Reality is that which, when you stop believing in it, doesn't go awayReceived on Wed Jul 02 1997 - 00:00:00 CEST