Specifying default tablespace when creating an user?

From: Brian Lavender <blavender_at_spk.usace.army.mil>
Date: Mon, 19 Jul 1999 21:17:38 GMT
Message-ID: <7n04l3$8fr$1@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:17:38 CDT