resetting user passwords

Is there a pl/sql package that will execute the statement 'ALTER user userid identified by newpass;' .

I would like to create a stored procedure that can change the password for
selected user ids and not other user ids and then grant execute on this procedure
to users on our help desk. This procedure is used to reset forgotten passwords.

I have tried dbms_sql and it does not seem to work. (parsing and then executing.)

Thanks for any help that can be provided. Received on Fri May 08 1998 - 10:25:11 CDT