creating new users

[softdrink]

I'm new to oracle, I installed my Oracle 8i. So far I login with scott/tiger to SqlPlus, to do my practice. I want to create new users. How do I do that?

thanks,

softdrink

 

[Turkbear]

You need to read more of the docs before trying to do DBA stuff since you will need to be connected as a user with enough rights to really mess things up in order to create new users.
Go to:

http://technet.oracle.com

and read the concepts and administration docs ( at least)
( you will need to register, but it is free and you will use this site a lot)

 

[softdrink]

thnaks, I will definetely do that but for now, is there a way to simply create a user for myself so I don't go with scott/tiger in it all the time?

 

[softdrink]

And I went on the site, where do I register and where can I find those docs. I'm looking abut I can't find them. If you can, pleae point me to the doc link, thanks, much appreciated.

softdrink

 

[Turkbear]

Hi,
This link goes directly to the archived product docs ( 8i is now considered old)

http://technet.oracle.com/docs/products/oracle8i/content.html

To create another user, log in as sys and use

create user user_name identified by password default tablespace some_tablespace_other_than_system temporary tablespace your_temp_tablespace_name;

substituting real names for the generic ones I used..
Then issue a

grant create session to user_name

Read the docs about what next...There is no substitute for reading to fully understand a powerful tool like Oracle
( This ain't Access )


then

 

[sem]

You should be granted CRATE USER priviledge at least, so you should connect as SYSTEM, not as scott.

 

[softdrink]

thanks , much appreciated

softdrink