OraFAQ Forum: Security » How can I allow a user to change their Oracle DB password?

Home » RDBMS Server » Security » How can I allow a user to change their Oracle DB password?

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

How can I allow a user to change their Oracle DB password? [message #220131]

Mon, 19 February 2007 01:09

ndahafa
Messages: 16
Registered: November 2006

Junior Member

hi,

Background:
We have a portal where users login and can run isqlplus queries, currently they have to log in twice i.e. to the portal and the DB.

I've been asked to come up with a way to allow them to change their passwords.
Portal side is fine, i found a solution.
DB side, I do not know how to do it. I need a script to run when the user clicks the change password button.
If there's a way to bypass the isqlplus login screen, this would actually be the better solution because then I also solve the problem of them having to log in twice.

I hope you understand my problem and can help. Links to relevant sites are also welcome.
thanks.

Report message to a moderator

Re: How can I allow a user to change their Oracle DB password? [message #220133 is a reply to message #220131]

Mon, 19 February 2007 01:15

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
If users using ISQLPLUS then there is option for CHANGE PASSWORD.
Workspace >>>> Preferences >>>> CHANGE PASSWORD.

regards
Taj

[Updated on: Mon, 19 February 2007 01:34]

Report message to a moderator

Re: How can I allow a user to change their Oracle DB password? [message #220141 is a reply to message #220133]

Mon, 19 February 2007 01:44

ndahafa
Messages: 16
Registered: November 2006

Junior Member

hi Taj, thanks for your quick reply.

the users do not get that screen, that's the one i use to write my queries which i then save as .sql and users access them through links available on the portal. when user clicks on one of those links he gets the isql*plus login screen (see attach1).
they don't have access to the change password option.

what i'm struggling with is: say i have a 'change password' html page with fields : old_password, new_password, confirm_password. the user will fill these in, click OK then the 'change password script' will be executed... this is the script i'm struggling to find/come up with.

thanks.

Attachment: attach1.doc
(Size: 101.50KB, Downloaded 2360 times)

Report message to a moderator

Previous Topic:	Encryption only one column
Next Topic:	Encryption in Oracle 9i Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 17:10:26 CDT 2025