Re: HELP - ORACLE SET PASSWORD

Hi Raed,

I 've implemented exactly the same feature in FORMS 4.x using the FORMS_DDL and LOGON built-ins. Obviously, the user should know the original pwd to change it. Feel free to contact me if you wanna take a look at the code.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.

Raed Turkmani <rturkman_at_nas.edu> wrote:


>We have a situation were we need to allow the end-user to modify 


>his/her own password from a front-end tool (i.e., SQL*FORMS, etc).

>We have created user accounts in Oracle and supplied our end-users

>with default passwords that they would like to alter.

>

>I have looked at all of the ORACLE provided systems packages,

>stored procedures and functions and could not locate one that could be

>called from the client application to alter an individuals account

>password.

>

>Contacted Oracle support, and they informed me that they do not have

>any pkg that meets my needs.

>

>Has anyone written a stored procedure, C program, PL/SQL script

>that provides such functionality to end-users? I am sure this

>question/requirement has come up before.

>

>Thanks in advance for all your help.

>

>RT - National Academy of Sciences.