Forum OpenACS Q&A: Response to Using a different tablespace ACS4.2 & Oracle 8.1.7

<P>Jennifer,

<P>Terminology-wise, what you are calling a "tablespace" is more properly called a "schema user" or "owner." (See the <a href="http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/c01intro.htm#15085">Oracle docs</A> for more details.)

<P>Your best bet is most likely to use something like
<PRE>
        alter session set current_schema = YOUR_APPLICATION_SCHEMA;
</PRE>
to change the resolution mechanisms to assume that all object names should be prefixed with <tt>YOUR_APPLICATION_SCHEMA</tt>. Alternatively (and, from a security standpoint, less desirably), you could create public synonyms for the objects that should be exposed to user <tt>jendy</tt>.