Nibble Guru - Computing queries demystified Thursday, January 08, 2009
Home
My Account / Register
Login / Logout
Post your Problem!
Search
About Us
Contact Us
List Home > Databases > Oracle >   [ Post New Problem ]

Welcome back !
TrackingID : 1858
Posted : Wednesday, November 24th, 2004 09:23:39 AM
By : superck
How to write SQL script to change password at first time?Configuration:
Hello,
I would like to know how to create a SQL script to force user change their password at the first login. 		Operating System : Microsoft Windows XP
CPU/Processor : AMD Athlon 2500 MHz
RAM : NEC Actual:512 MB
Motherboard : Gigabyte
Hard Disk : Maxtor, Space: 120 GB, RPM:7500
Monitor : Topcon 17"
Video Card : WinFast
CD Drive : LiteOn 52 X
Mouse : Logitech
Keyboard : Logitech
Printer : HP
Scanner : HP

Related Problems :
Comments :
Re: How to write SQL script to change password at first time? by scorpio on November 25th, 2004 01:31:01 AM
Have a column 'isfirstlogin' in your table where you are storing the user information.

When you register a user set this value to 1.

When the user logs in and the value of this field is 1 then ask him to change the password and set the value of this field to 0.
next time since the value is not 1. he will not be forced to change his password.

this way you will get what you want :)
Re: what should I write for host string in oracle 8i in windows XP by Anonymous Ghost on February 15th, 2005 09:24:06 AM
what should I write for host string in oracle 8i in windows XP

Related Problems :
Post a Note :
UserName (not required in anonymous posts)
Password (not required in anonymous posts)
Post Anonymous (check this only if you wish to post anonymously.)
Subject
Comment (limited HTML allowed)
List Home > Databases > Oracle >   [ Post New Problem ]
Copyright © 2001-2009, Nibble Guru