Re: User Update of Passwords
From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 29 Sep 1998 15:37:25 GMT
Message-ID: <361dfe86.98166375_at_192.86.155.100>
Date: Tue, 29 Sep 1998 15:37:25 GMT
Message-ID: <361dfe86.98166375_at_192.86.155.100>
A copy of this was sent to wfrye_at_mnsinc.com (if that email address didn't require changing) On Tue, 29 Sep 1998 12:59:18 GMT, you wrote:
>Is there a technique by which we can create a routine through which users can
>update their own passwords?
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
quite simply they may execute the following sql statment:
ALTER USER <theirname> IDENTIFIED BY <newpassword>;
If you are using forms, you can do this quite easily with forms_ddl() by putting the above into a string and executing it...
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
-- http://govt.us.oracle.com/ -- downloadable utilities ---------------------------------------------------------------------------- Opinions are mine and do not necessarily reflect those of Oracle Corporation Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it.Received on Tue Sep 29 1998 - 17:37:25 CEST