Re: Adding a new user

In article <980010798.266039_at_news1.bigplanet.com>, albrrat_at_hotmail.com says...
> I just received a CD pack for oracle and installed 8i personal edition. I am
> working with this program in school. after installing it on my home system,
> I could not login to sql plus. i found how to login using INTERNAL/ORACLE
> but how do I add a new username and password so I dont have to log on with
> INTERNAL/ORACLE?
>
>
>

The first thing to do is to find out what tablespaces you have:

select tablespace_name
from dba_tablespaces
order by tablespace_name;

That should give you something that looks like USERS and TMP or TEMP.

Then:

create user ${user}
identifiedy by ${password}
default tablespace ${USERS}
temporary tablespace ${TEMP}
quota unlimited on ${USERS};

HTH; Doug

-- 
-------------------
Douglas K. O'Leary
Senior System Admin
dkoleary_at_mediaone.net