Yes, make default tablespace <new tables you want> for that account.
SO they would create new objects in new default tablespace


-----Original Message-----
From: Johnson, Shaunn [mailto:[Email Address Removed]
Sent: Thursday, February 26, 2004 11:27 AM
To: LazyDBA.com Discussion
Subject: silly tablespace question

I know this is a Microsoft question, but I can't
find anything useful in groups.google.com.
I'm trying to look into the MS list now ...

Is it possible for MS Access users change the
tablespace they create data on within the
MS Access program?

I have a tablespace that is filling up and I need
to move things around. While I can not do anything
about the SCHEMA right now, I need to have the
users who connects to the database (Oracle 9i)
to connect to the same schema, but build their tables
into different tablespaces.

Is this possible?

Thanks!

-X
-------------------------------------------------------------------------------------

The information contained in this message is proprietary of Amdocs,

protected from disclosure, and may be privileged.

The information is intended to be conveyed only to the designated recipient(s)

of the message. If the reader of this message is not the intended recipient,

you are hereby notified that any dissemination, use, distribution or copying of

this communication is strictly prohibited and may be unlawful.

If you have received this communication in error, please notify us immediately

by replying to the message and deleting it from your computer.

Thank you.

-------------------------------------------------------------------------------------
Oracle LazyDBA home page