Re: Changing a user's default tablespace.

From: Paul <paul_at_not.a.chance.ie>
Date: Mon, 7 Jun 2004 10:01:11 +0100
Message-ID: <MPG.1b2e3f37c0be988c98994a@news1.eircom.net>

david.sharples3_at_ntlXworld.com says...

> if you change quota to 0 on that tablespace then you will get an error when
> you try to create any object - however if you have dba rights then it will

Suppose you have a user 'Billy' whose default tablespace is SYSTEM, and then you as dba decide to give Billy a default tablespace of FRED, and *_then_* you give Billy a quota of 0 on the SYSTEM tablespace, my question is what happens Billy's data/objects that were in SYSTEM.

On giving Billy a new default tablespace, are his objects in SYSTEM moved, or are they still in SYSTEM? That's my question really.

Paul...

-- 
plinehan  y_a_h_o_o  and d_o_t  com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.

"XML avoids the fundamental question of what we should do, 
by focusing entirely on how we should do it." 

quote from http://www.metatorial.com

Received on Mon Jun 07 2004 - 04:01:11 CDT