Re: How to change password upon expiration?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 7 Feb 2001 13:38:48 +0100
Message-ID: <t82gvncna1nc6c@beta-news.demon.nl>

"nick" <nick-love_at_juno.com> wrote in message news:t81ga4k3uqsk50_at_corp.supernews.com...
>
> zzchang wrote:
> >
> >
> > All,
> >
> > I am using ORACLE8i and I need to implement the functionality to allow
> > users to change their passwords upon expiration of their passwords. I
> > wonder if the users themselves can do this.
> >
> > It appears to me if a password is expired and only DBA can modify the
> > password. Is this true?
> >
> > Thanks,
> >
> > Chang
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
> Well that's true, but if the user has the ALTER USER privilege then he/she
> can do it themself. Otherwise the DBA is responible it.
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/

However if the user has ALTER USER privilege, he can alter *ANY* user *INCLUDING SYS* Regards,

Sybrand Bakker, Oracle DBA Received on Wed Feb 07 2001 - 06:38:48 CST