Re: Change Oracle password after expiration using Visual Basic

From: Pat Minnis <pminnis_at_indianaonline.net>
Date: Wed, 15 Dec 1999 05:15:46 GMT
Message-ID: <6uF54.120$EU4.13158@news.goodnet.com>

Assuming you are wanting to front-end some other application that actually logs into the database:

If you have a way to pass the userid/password to the other application (in Oracle Forms, F45RUN32 form userid='user/pass'),

1.    You could ask logon credentials in VB
2.    Once logged in, you could change the password as required
3.    After changed, you could reconnect using the new password or call the

application directly with the new credentials

chartier_at_my-deja.com wrote in message <82u15e$t9n$1_at_nnrp1.deja.com>...
> I need to know how to change the users
>(Oracle 8.0.4) password via Visual Basic (v6.0
>SP3) and RDO. If the users password is expired,
>the proper error message is returned, but because
>the user isn't connected to the database, I
>cannot change the password with the "ALTER xxx
>IDENTIFIED BY xxx" sql. Anyone got any
>suggestions??
>
> I've examined the OraSession object and there
>is no "ChangePassword" method as suggested by
>someone, as for the OraServer object, I've been
>unable to find any reference to it anywhere in VB
>or elsewhere, except in 1 message I found in this
>forum and there where no details about how to use
>or aquire it. I CANNOT log on to the database
>using a generic account that has the proper
>rights as any accounts on the database need to
>have their passwords changed/expired every 90
>days. Any help would be appreciated .. thanks ..
>
> Prescott Chartier
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Dec 14 1999 - 23:15:46 CST