Re: Changing Oracle Database Password
Date: 1998/02/06
Message-ID: <34DB12B6.663A_at_CGI.CA.NOSPAM>#1/1
Listen folks...nobody likes to be spanked in public...especially if the ones doing the criticizing turn out not to be correct.
(Your ideas may be better...but that doesn't necessarily make you correct...or the other incorrect)
Anywho...I expect sometimes egos get fragile enough that they feel the have to berate, put down, humiliate or otherwise try to belittle others...when that happens, I urge you to get away from your computer, away from the net and maybe go to a biker bar.
Jonathan
Robert Rice wrote:
> >>alter user <username> identified by <new password>
> >
> >>No you'right...it's not GUI, but even a non-technical
> person can type
> >>the sentence.
> >
> >No you are wrong! This works only if the users have the 'alter user'
> privilege, which they
> >should not!
>
> No you are wrong! You only need ALTER USER privilege to
> issue the
> command against a user other than yourself or to perform a
> privileged
> operation (such as changing your default tablespace etc.).
> You can
> try the following:
> create a new user with only connect role:
> SQL> GRANT CONNECT TO FRED IDENTIFIED BY FRED;
> Grant succeeded.
>
> SQL> CONNECT FRED/FRED
> Connected.
>
> SQL> ALTER USER FRED IDENTIFIED BY NODDY;
> User altered.
>
>
Received on Fri Feb 06 1998 - 00:00:00 CET