CREATE USER XXXX IDENTIFIED BY XXXX DEFAULT TABLESPACE XXXXX TEMPORARY
TABLESPACE XXXX;
Brian Lavender wrote in message <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 Thu Jul 29 1999 - 12:03:33 CDT
