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: USERs in ORACLE

Re: USERs in ORACLE

From: Dave Francis <d_a_francis_at_yahoo.co.uk>
Date: Wed, 15 Aug 2001 21:33:46 +0100
Message-ID: <3b7adc80_3@mk-nntp-1.news.uk.worldonline.com>


I get the feeling that this is going to run and run....... ;-)))))

Dave

Markus Schumann wrote in message ...
>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 Wed Aug 15 2001 - 15:33:46 CDT

Original text of this message

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