OraFAQ Forum: Security » resetting passwords for user accounts

Home » RDBMS Server » Security » resetting passwords for user accounts

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

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?

Report message to a moderator

Re: resetting passwords for user accounts [message #128610 is a reply to message #128164]

Tue, 19 July 2005 14:33

plusk
Messages: 3
Registered: July 2005

Junior Member

disrgard....we found a solution.

Report message to a moderator

Re: resetting passwords for user accounts [message #138510 is a reply to message #128610]

Thu, 22 September 2005 05:47

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,,

Will you post your solution for the question that you had asked in your first post ... Wink

'Knowledge increses by sharing'

Regards
Always Friend sunilkumar

[Updated on: Thu, 22 September 2005 05:47]

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	EMC Control Center Oracle Database access
Next Topic:	DDL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 16 23:42:51 CDT 2025