Re: Changing Oracle Database Password

From: Jonathan Trifts <Jonathan.Trifts_at_CGI.CA.NOSPAM>
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)

This list/newsgroup is supposed to foster a healthy working relationship where other developers, analysts, dba's and whatever oracle users happen to be out there come together to help each other and make each of our lives just a little bit easier...or at least more efficient.

There is no need to post with the "AHA...I got You!...You're Wrong...You don't know what you're talking about" tone of voice. This will just serve to make people less apt to give help. Again and again we need to remind ourselves that the net does not by default give us the right to be nasty.

I once read (I think it was at the TEN site (The Entertainment Network) something to the effect that users should adopt the bruiser policy. The idea is that if you wouldn't say something at a biker bar to some big tough guy with Bruiser tattooed to his forehead then you probably shouldn't say it on the net. (...apologies to TEN for getting the story wrong...)

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

Original text of this message