| resetting passwords for user accounts [message #128164] |
Fri, 15 July 2005 08:24  |
plusk
Messages: 3
Registered: July 2005
|
Junior Member |
|
|
We are currently developing a web appplication to reset passwords
for database users (v 9i). I have read information in the manuals that instead of using the ALTER command to do this, that is is better to use OCIPasswordChange() function. I just can't seem to find any other information about it.
There seems to be a problem with a current app that will not accept a password that begins with a numeric character....
The password is picked from a text box, and it's being passed
into the sql code as a string....but if you attempt to use anything beginning with a number, it produces an Int32 error.
probably in the coding, but I've tried everything I know to do, to no avail.
Any ideas on what the problem might be, and any suggestions on another way to accomplish this?
|
|
|
|
|
|
|
|
| Re: resetting passwords for user accounts [message #139822 is a reply to message #138510] |
Thu, 29 September 2005 14:32  |
plusk
Messages: 3
Registered: July 2005
|
Junior Member |
|
|
Sorry for not posting sooner....been really busy!
The following code is what we found works...it's written in vb.net, using ODP.NET:
the password is picked up from a text field:
Dim sqlReset As String = "alter user " & uname & " identified by " & """" & txtNewPass.Text & """"
This will allow passwords beginning with either integer or alpha.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
