Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Specifying default tablespace when creating an user?

Re: Specifying default tablespace when creating an user?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 19 Jul 1999 23:54:35 +0200
Message-ID: <932421253.20036.0.pluto.d4ee154e@news.demon.nl>


create user <username>
identified by <password>
default tablespace <def tablespace>
temporary tablespace <temp tablespace>; /

Hth,
Sybrand Bakker, Oracle DBA

Brian Lavender <blavender_at_spk.usace.army.mil> wrote in message news:7n04l3$8fr$1_at_nnrp1.deja.com...
> I just created a user in my database. My DBA configured my database and
> she is not here today. I am trying to create a user in my database. I
> logged in and I issued the command from sqlplus
> SQL> create user fred identified by foobar;
>
> I was able to query the dba_user table and I noticed the user I created
> has a default table space of system along with a temp tablespace of
> system. All the other users have the default tablespace of myspace and a
> temp tablespace of temp. It looks as if the user I created has a default
> and temp tablespace that he should not have. When I create an user, how
> do I specify what tablespace he has a default and as temp?
>
> brian
> --
> Brian E. Lavender
> US Army Corps of Engineers -- Programmer / Systems Analyst
> Sacramento, CA (916) 557-6623
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
Received on Mon Jul 19 1999 - 16:54:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US