Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: User Control of Passwords
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
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