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

Home -> Community -> Usenet -> c.d.o.server -> Re: resetting user passwords

Re: resetting user passwords

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Wed, 13 May 1998 22:07:05 GMT
Message-ID: <01bd7ecb$8c924920$a504fa80@mndnet>


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

Original text of this message

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