Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » html_db change password (html_db, oracle10g)
html_db change password [message #308962] Wed, 26 March 2008 01:38 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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;
Previous Topic: dynamically changing the column values color
Next Topic: Print server Configuration
Goto Forum:
  


Current Time: Sat Apr 20 00:08:57 CDT 2024