Re: How do PowerBuilder clients change Oracle Passwords?

tspj_at_ucs.ubc.ca (Patrick Johnson) writes:

>I hope I'm missing something, but I can't figure out how to provide users
>of Windows client apps built in PowerBuilder with a convenient way to change
>their Oracle passwords (preferably within the same application).
 

>PowerBuilder doesn't permit the inclusion of an ALTER USER statement in a
>script, and PL/SQL doesn't seem to permit this either, so I can't sneak round
>it that way.

   I've always used: GRANT CONNECT TO username IDENTIFIED BY new-passwd;    

   Has this changed in Oracle 7 ?

R.H.

>From a cursory inspection, it didn't look as if MS Access would permit this
>either. Can it be done in VisBasic?
 

>Maybe someone else out there has already met and addressed this problem? - any
>pointers would be much appreciated.
 

>TIA,
 
>...PJ (Patrick Johnson)
Received on Tue Dec 07 1993 - 05:06:48 CET