html_db change password [message #308962] |
Wed, 26 March 2008 01:38 |
prasanna_anbu
Messages: 34 Registered: November 2006 Location: india
|
Member |
|
|
Hi I create a change password region for my customer in that i need to compare the password which the user used to login and in the chage password region he enter the old password.
for example
in my change password region i create a password text item
named P1_password
i want to compare this p1_password and app_password can any one help on this
|
|
|
Re: html_db change password [message #309144 is a reply to message #308962] |
Wed, 26 March 2008 10:16 |
dr.s.raghunathan
Messages: 540 Registered: February 2008
|
Senior Member |
|
|
hi
I created a users table with password wherein
i have incorporated tabnames, pagenames, regionnames
and permission status as Y or N.
Using this table I controlled all the objects through
conditional display using sql querry exists...
However comparison db pw and apps pw has been handled
on the sample application provided along with Apex 3.0
for example apex_cust some thing like that.. check in
the sample application presented..
Yours
dr.s.raghunathan
|
|
|
Re: html_db change password [message #309344 is a reply to message #309144] |
Thu, 27 March 2008 03:05 |
prasanna_anbu
Messages: 34 Registered: November 2006 Location: india
|
Member |
|
|
Thanks for your reply. now i used to compare the p101_password item with my p1_password and it is working fine.
i used the below condition
if :P101_PASSWORD = :P1_PASSWORD then
HTMLDB_UTIL.CHANGE_CURRENT_USER_PW (:P1_NEW_PASSWORD);
END IF;
|
|
|