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