How to creat user in Oracle? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

How to creat user in Oracle?

How to creat user in Oracle?# Database - 数据库

l*s2003-10-20 07:10

1 楼

I recently start learning the Oracle 9i. I installed the Oracle
in Linux under user Oracle. So when I login as Oracle, I type
sqlplus
Then it asks me user and password. I am confused about this. Since
I have not been able to open the Oracle database yet, how can I
have a user and password for the database? I must be able to login
in as an administrator and for the first time I should have a
default password. Is this right? I learnt that I can prompt to
sqlplus without login. But can I do any adm

p*e2003-10-20 07:10

2 楼

Try scott/tiger. That's a typical set of username/password. There should be a
few users already created in your Oracle database. system/manager should work
too.

【在 l***s 的大作中提到】

: I recently start learning the Oracle 9i. I installed the Oracle
: in Linux under user Oracle. So when I login as Oracle, I type
: sqlplus
: Then it asks me user and password. I am confused about this. Since
: I have not been able to open the Oracle database yet, how can I
: have a user and password for the database? I must be able to login
: in as an administrator and for the first time I should have a
: default password. Is this right? I learnt that I can prompt to
: sqlplus without login. But can I do any adm

l*s2003-10-20 07:10

3 楼

great! scott/tiger works! ^_^ thanks so much. btw, if a select result is
too long, how to slow it down and shown in multi-pages? like the |more
does for UNIX commands?
thank you

【在 p*********e 的大作中提到】

: Try scott/tiger. That's a typical set of username/password. There should be a
: few users already created in your Oracle database. system/manager should work
: too.

p*e2003-10-20 07:10

4 楼

With SQL*Plus, I don't know if there is a way to make it stop at the end of
each page, like the |more does. You might have to try a different querying
tool. SQL*Plus is about the least user-friendly tool I've used.

be a
work

【在 l***s 的大作中提到】

: great! scott/tiger works! ^_^ thanks so much. btw, if a select result is
: too long, how to slow it down and shown in multi-pages? like the |more
: does for UNIX commands?
: thank you

m*t2003-10-20 07:10

5 楼

When you are in sqlplus,
spool results.txt
select * from your table
spool off
would write all the rows selected to results.txt.

【在 l***s 的大作中提到】

: great! scott/tiger works! ^_^ thanks so much. btw, if a select result is
: too long, how to slow it down and shown in multi-pages? like the |more
: does for UNIX commands?
: thank you

l*s2003-10-20 07:10

6 楼

I see. so there aren't commands to do the |more thing in sqlplus...
thanks..

【在 p*********e 的大作中提到】

: With SQL*Plus, I don't know if there is a way to make it stop at the end of
: each page, like the |more does. You might have to try a different querying
: tool. SQL*Plus is about the least user-friendly tool I've used.
:
: be a
: work

l*s2003-10-20 07:10

7 楼

great, this way worked for me..thanks alot. ^_^

【在 m******t 的大作中提到】

:
: When you are in sqlplus,
: spool results.txt
: select * from your table
: spool off
: would write all the rows selected to results.txt.

l*s2003-10-20 07:10

8 楼

oh, I just found something. I would like to share with your guys...^_^
we can use
set pause on;
to activate the paging feature, so that the ouput will pause at the end of
each screen...^_^
thanks

【在 l***s 的大作中提到】

: I see. so there aren't commands to do the |more thing in sqlplus...
: thanks..

p*e2003-10-20 07:10

9 楼

Nice to know. Thanks :)

of
querying

【在 l***s 的大作中提到】

: oh, I just found something. I would like to share with your guys...^_^
: we can use
: set pause on;
: to activate the paging feature, so that the ouput will pause at the end of
: each screen...^_^
: thanks

l*s2003-10-20 07:10

10 楼

hi, you know what? this scott/tiger pair worked for almost two days
and not it stops working...:( is it designed to be like that? let you
work with it for only the beginning? or what? now i have no user and
passwork to use le...555

【在 p*********e 的大作中提到】

: Try scott/tiger. That's a typical set of username/password. There should be a
: few users already created in your Oracle database. system/manager should work
: too.

m*t2003-10-20 07:10

11 楼

use SYS/change_on_install, or SYSTEM/manager to log in as SYSDBA, then create
new users.
BTW, do take a hint from the default password and change it after the first
time you log in. 8-)

【在 l***s 的大作中提到】

: hi, you know what? this scott/tiger pair worked for almost two days
: and not it stops working...:( is it designed to be like that? let you
: work with it for only the beginning? or what? now i have no user and
: passwork to use le...555

l*s2003-10-20 07:10

12 楼

both the SYS/change_on_install and the SYSTEM/manager are said to be :
ORA-01017: invalid username/password; logon denied
:(

【在 m******t 的大作中提到】

:
: use SYS/change_on_install, or SYSTEM/manager to log in as SYSDBA, then create
: new users.
: BTW, do take a hint from the default password and change it after the first
: time you log in. 8-)

m*t2003-10-20 07:10

13 楼

Nobody else uses that oracle instance, right? Try those passwords again with
all upper-cases - I don't remember which cases they are...

【在 l***s 的大作中提到】

: both the SYS/change_on_install and the SYSTEM/manager are said to be :
: ORA-01017: invalid username/password; logon denied
: :(

s*e2003-10-20 07:10

14 楼

after you log in to the oralce,
you can try this:
sqlplus /nolog
and you can connect as sysdba.

s*e2003-10-20 07:10

15 楼

by the way, did you create your database? maybe you need to create your
database first. you can use "dbca" command and create your database.

s*m2003-10-20 07:10

16 楼

You may want to create a database first before you create any user. Login as
dba create database, then create user with proper privilege in your database.
On Orace machine
sqlplus /nolog;
connect system as sysdba;
######Then create your user#############3
create user yourusername identified by 'password';
grant connect to yourusername;
grant resource to yourusername;
You need to setup appropriate tablespace for your user so user will not put
junk into system tablespace.

【在 s*******e 的大作中提到】

: by the way, did you create your database? maybe you need to create your
: database first. you can use "dbca" command and create your database.

l*s2003-10-20 07:10

17 楼

this is very helpful...many thanks...^_^

【在 s***m 的大作中提到】

:
: You may want to create a database first before you create any user. Login as
: dba create database, then create user with proper privilege in your database.
: On Orace machine
: sqlplus /nolog;
: connect system as sysdba;
: ######Then create your user#############3
: create user yourusername identified by 'password';
: grant connect to yourusername;
: grant resource to yourusername;