Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: User Control of Passwords

Re: User Control of Passwords

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 01 Oct 1998 17:37:50 GMT
Message-ID: <3622bdbc.107724509@192.86.155.100>


A copy of this was sent to wfrye_at_mnsinc.com (if that email address didn't require changing) On Thu, 01 Oct 1998 14:16:57 GMT, you wrote:

>Does anyone know how to write code that will allow users to change their own
>passwords without giving them the authority to change other people's?
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Anyone connected to Oracle may issue:

SQL> alter user <theirname> identified by <newpassword>;

If you are in forms for example, you could use forms_ddl() to execute a string that contained their 'alter user' command.  

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 Thu Oct 01 1998 - 12:37:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US