Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: resetting user passwords
I have a SQL*Plus script that lets our users change their own passwords.
We have put this in our SQL*Menu. One less headache for DBA or help desk.
If interested email to
suresh.bhat_at_mitchell-energy.com
Rob Joss <_rob_joss_at_lilly.com> wrote in article
<355323D6.D7F9F8C4_at_lilly.com>...
> 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 Wed May 13 1998 - 17:07:05 CDT