Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Plus doesnt work

Re: SQL Plus doesnt work

From: Jac. _at_ xs4all <_at_>
Date: Fri, 20 Nov 1998 22:29:42 +0100
Message-ID: <734mup$ir5$1@news2.xs4all.nl>


Oracle databases come with a predefined user system (password: manager) and sys (password: change_on_install).

Connect to sql*plus using one of these users and you will be able to change the password of any user, using the command

alter user user_name identified by new_password;

In this case you just changed the user's password, so you know it.

Hope this helps

Jac.

VB BV wrote in message <732ujv$cd7_at_ustsu10.ust.hk>...
>Hi,
>
>A naive question: I have just finished installing Oracle8 enterprise for
NT,
>and I used the dB assistant to create a dB called myDB. Now when I try to
>run the SQL Plus, and enter the password etc it gives me an error of
>password not recognized.
>
>Is there some way I can check the correct password etc?
>
>Thanks, please mail me personally as well.
>
>Regards,
>Vaibhav
>
>
Received on Fri Nov 20 1998 - 15:29:42 CST

Original text of this message

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