Re: CHANGING PASSWORDS

From: C. Mason <cmason_at_aai.arco.com>
Date: 1997/09/15
Message-ID: <01bcc22f$339f9880$ef6ae288@ato-10231>#1/1

Not true. ALTER USER is a system privilege that allows the grantee to alter ANY user's password, default tablespace, etc. If you create a user XYZ and grant CREATE SESSION to XYZ so XYZ can connect to ORACLE, then XYZ can issue the command: ALTER USER XYZ IDENTIFIED BY ZZZ ;

Chinna <jchinna_at_enron.com> wrote in article <01bcbfbe$4e1ac540$06f7fb9b_at_eoghou1325.eog.enron.com>...
> Not everybody can change their passwords. The user must have ALTER USER
> privilege to do that. The admin person can grant that privilege to the
 user
> or can
> create a role and grant the role to the user.
>
> let me know if this helped.
>
> Chinna
>
> AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu> wrote in article
> <3405B411.2F5_at_charlie.cns.iit.edu>...
> > Hagen wrote:
> > >
> > > Is it possible to have someone change their own password in oracle
> > > without having Admin. right, or is it possible to give admin rights
 so
> > > that they can ONLY change their password and not have any other admin
> > > rights. Thanks.
> > >
> > > Hagenj_at_mail.dec.com
> >
> > yes, user can change his own password.
> >
> > SQL> ALTER USER SCOTT IDENTIFIED BY SCOTT;
> >
> > HOPE THIS HELPS
> >
> > AMARENDRA
> > --
> >

---

> > AMARENDRA B NETTEM 5039 N E River Road, Apt. 1A
> > Certified Oracle DBA NORRIDGE, IL 60656
> > Whittman-Hart Inc.,
> > Chicago, IL 60656.
> >
> > Ph.No. (708) 583 9870 (H) E-mail: nettama_at_charlie.cns.iit.edu
> > (312) 813 6758 (W) anettem_at_whittman-hart.com
> >
> > Homepage: http://www.iit.edu/~nettama
> >
> > **********************************************************************
> >
>
Received on Mon Sep 15 1997 - 00:00:00 CDT