OraFAQ Forum: Windows » Change Password

Home » Infrastructure » Windows » Change Password (Visual Basic, 6.0, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Change Password [message #306967]

Mon, 17 March 2008 06:41

visairam
Messages: 11
Registered: March 2008
Location: Bangalore

Junior Member

Hi,

My name is ram, Iam working as software engineer.

Currently iam working on an application having Oracle as backend and VB(Visual Basic) as front end.

The problem is :

1) When the password of an user expires(passes grace period) and user tries to login the system is throwing an error "Password expired". Error code is 28001.

2) When the user gets the temporary password from dba and tries to
login still it is throwing the same kind of error.
Error code is 28001.

But when i see other oracle tools, they are able to identify the temporary passwords and are prompting for change password, which iam not able to do from my application (VB).

How can i identify from my application that the password is temporary, as the oracle is throwing same error for both the cases(For expired password as well as for temporary password).

Please help me in this regards.

Thanks in advance.

Bye
Ram

Report message to a moderator

Re: Change Password [message #306969 is a reply to message #306967]

Mon, 17 March 2008 06:47

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to trap the 28001 error in your application and then raise a dialog box.
This is how work the other applications.

Regards
Michel

Report message to a moderator

Re: Change Password [message #306976 is a reply to message #306969]

Mon, 17 March 2008 07:16

visairam
Messages: 11
Registered: March 2008
Location: Bangalore

Junior Member

Hi Michel,

Thanks for responding.

I can trap that error.

But the problem is, when the password actually expires then also, iam getting the same error from oracle.

There is a chance that i will show the dialog box prompting for the password change, when the password actually expires. I want the user to approach the dba for getting a temporary password.

Please understand the problem.

If it is not clear tell me.

Thanks you
Ram

Report message to a moderator

Re: Change Password [message #306992 is a reply to message #306976]

Mon, 17 March 2008 08:07

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The user does not need a dba to change his password.
You can popup the box and let him change right when you get the 28001 error just like SQL*Plus does.

Code: [Select all] [Show/ hide]

SYSTEM> drop user t;

User dropped.

SYSTEM> create user t identified by t password expire;

User created.

SYSTEM> grant create session to t;

Grant succeeded.

SYSTEM> connect t/t
ERROR:
ORA-28001: the password has expired

Changing password for t
New password:
Retype new password:
Password changed
Connected.
T> sho user
USER is "T"

Regards
Michel

Report message to a moderator

Re: Change Password [message #307223 is a reply to message #306992]

Tue, 18 March 2008 02:54

visairam
Messages: 11
Registered: March 2008
Location: Bangalore

Junior Member

Hi Michel,

As per our application we want the user to approach the DBA to get the new password.

If the user tries to login with the expired password, i can show the dialog box asking for the change password. But, i want the DBA to generate the new temporary password for the user, whenever a password expires.

Thanks & Regards
Sairam Virella

Report message to a moderator

Re: Change Password [message #307230 is a reply to message #307223]

Tue, 18 March 2008 03:37

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In this case, just trap the error and pop up an information box saying "your password has expired, contact your DBA"

Regards
Michel

Report message to a moderator

Re: Change Password [message #307236 is a reply to message #307230]

Tue, 18 March 2008 04:02

visairam
Messages: 11
Registered: March 2008
Location: Bangalore

Junior Member

Hi Michael,

Hey please understand.

I can trap the error and show the dialog box as you said.

But, when the user gets the temporary password from the DBA and tries to login, still i get the same error as it is temporary password.

Report message to a moderator

Re: Change Password [message #307245 is a reply to message #307236]

Tue, 18 March 2008 04:18

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Then you are in deadlock unless your application can know this is a temporary password and not a regular one that is expired.
For instance, create a "user" table with something that can tell you that the current password is a temporary one.

Regards
Michel

Report message to a moderator

Re: Change Password [message #307334 is a reply to message #307245]

Tue, 18 March 2008 09:00

visairam
Messages: 11
Registered: March 2008
Location: Bangalore

Junior Member

Hi Michael,

Please tell me how to set the expiry of the user to a certain period.

For instance, a given user should expire in next 1 hour.

Please tell me.

Thanks & Regards
Ram

Report message to a moderator