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: CHANGING PASSWORDS

Re: CHANGING PASSWORDS

From: Gary Johnson <BLACKHAWK_at_email.msn.com>
Date: 1997/09/05
Message-ID: <01bcb9cd$74508700$482d2299@blackhawk>#1/1

Hagen. To have the User change their own passwords they simply need to have RESOURCE granted to them. They can then change their password by using the following:

 alter user scott identified by tiger2;

If you look at the permissions granted to the sample user Scott you will find it has Connect and Resource roles as well as unlimited tablespace.

Hope This Helps!
Gary

-- 
Blackhawk_at_MSN.Com
GERJOH_at_HBSI.COM

Hagen <hagenJ_at_mail.dec.com> wrote in article
<33FB7E6A.2487_at_mail.dec.com>...

> 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
>
Received on Fri Sep 05 1997 - 00:00:00 CDT

Original text of this message

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