Re: USERs in ORACLE

From: <alex_at_alexnet.fr>
Date: Sun, 5 Aug 2001 16:08:04 +0200
Message-ID: <9kjjit$3m5$1@reader1.imaginet.fr>

system/manager
sys/change_on_install

But don't spend too much time connected like system or sys :-) Use system only to create the first administrator:

=======================================================>

alter user sys identified by <new password>;

create user aminadmin identified by <password>; grant dba to aminadmin;

connect aminadmin/<password>
create table ...
...

<=======================================================

Then use sys or system only when asked by the documentation!

Denis ALEXANDRE (Oracle since 1986): alex_at_alexnet.fr AlexNet: http://www.alexnet.fr/

"Amin Emami" <Amin_Emami_at_yahoo.com> a écrit dans le message news: 9kjic4$4u5hi$1_at_ID-101160.news.dfncis.de...
> hi folks,
>
> I've installed Oracle 81 on Win2000 but I've got a problem now!
> I don't know what the passwords for the default users there is in the
> system.
> For example, what are the passwords of SYS or SYSTEM ?
>
> I've always worked with ORACLE at work and I don't know much more
> administration stuffs.
>
> Any help on these admin users is welcome.
>
> Thanks,
> Amin
>
>
>
>
Received on Sun Aug 05 2001 - 09:08:04 CDT