Re: Newbie

By default oracle require these passwords:

user: internal
pass: oracle

user: system
pass: manager

If you want to create additional users, connect as any of the above and type:

create user YourName identified by YourPassword;

To logon with this new user you must grant it to create a session, like

grant create session to YourName;

Then you will probably be able to create tables in YourName users schema, you need to grant create table:

crant create table to YourName;

etc etc etc...

It might also be a good idea to set a default tables space to user YourName, otherwise default table space will be system table space.

A little more than you asked for but I suppose I spared you a couple of questions, good luck!

//Jonas

In article <8kuctj$c8o$1_at_dragon.infopro.spb.su>,   "Alexander Shlega" <ashlega_at_hotmail.com> wrote:
> Hello, gurus.
>
> Could somebody tell me, why after installing Oracle 8.1 and
 creating a new
> database I can not
> connect to that database from Management console? Oracle asks me for
> username/password..
>
> Alexander
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 17 2000 - 00:00:00 CDT