Setting up users [message #2363] |
Tue, 09 July 2002 21:00 |
Jeremy
Messages: 10 Registered: September 2000
|
Junior Member |
|
|
I am having a real newbie day. First, I have installed Oracle 8i for win 2k. I am trying to do some sql and pl/sql stuff, and can not even get a user set up on this database. I have used the pre set one with the user scott, and forgot the password. But I would like to know step by step if someone has the patience on setting up users and their passwords on this program. Thanks a bunch.
Jeremy
|
|
|
|
Re: Setting up users [message #2396 is a reply to message #2363] |
Wed, 10 July 2002 19:11 |
christopher
Messages: 25 Registered: September 2000
|
Junior Member |
|
|
connected to the db as a dba user (sys or system).
SQL> CREATE USER username
IDENTIFIED BY password
[[TEMPORARY TABLESPACE tsname]]
[[DEFAULT TABLESPACE tsname]]
;
SQL> GRANT connect TO username;
GRANT ???? TO username;
|
|
|