Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Adding a new user
Doug O'Leary wrote:
>
>
> 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
Grant connect to ${user};
Grant resource to ${user};
......
Tho Nguyen
-- Posted via CNET Help.com http://www.help.com/Received on Sun Jan 21 2001 - 20:30:05 CST