Re: USERs in ORACLE

From: Markus Schumann <go4shoe_at_hotmail.com>
Date: Mon, 06 Aug 2001 01:42:37 GMT
Message-ID: <hCmb7.220457$mG4.100866689@news1.mntp1.il.home.com>

existing users:

User, Passwd

'sys', 'change_on_install'
'system', 'manager'
'internal', 'oracle'
'scott', 'tiger'

to create a new user 'my_user; with passwd 'my_passwd'

1.) start: sqlplus
2.) login as "system" with passwd "manager"

3.) create user as follow

SQL> create user my_user identified by my_passwd default tablespace users temporary tablespace temp;

4.) grant rights to connect etc.

SQL> grant connect, resource to monopoly

Markus Schumann

"Amin Emami" <Amin_Emami_at_yahoo.com> wrote in message news:9kji9i$4n0s8$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 - 20:42:37 CDT