Re: [?] Schemas, Namespace, and Projects

Hi Brad,

    I run everything in a single Oracle instance. For each project I create a user who owns the project and has its own tablespace and datafiles (I am running on AIX and use JFS rather than raw partitions). At the time tables are created for the projects, under the projects userid the necessary permissions are granted to the appropriate subset of our standard user accounts.

    When the project is completed I am then able to export the user and then drop the tablespace including contents and delete the datafile. This simplifies management of projects -- a major consideration since at any one time we have over 100 projects, almost all of which will be completed within less than a year.

regards

Jerry

Bradley G. Smith wrote in message ...
>I am relatively new to Oracle. I am also building a set of analysis
>tools for in-house use with data in Oracle instances. These analysis
>tools will be used in the context of Projects that are worked on by
>teams. During the analysis process numerous tables are created by the
>team. Table lifetimes vary from hours to months. These are in
>addition to the "core" corporate data tables.
>
>I have found that that controlling namespace for these
>project-related tables is difficult in Oracle. I would like to create
>a schema for each project and then have the analysis tools place
>project-related tables in that schema with access grants to all
>project members. It seems however, that a schema is tied explicitly
>to a user id and cannot be created independantly of user ids. Is
>there a mechanism for controlling table namespace other than schemas?
>
>Thanks,
>
>Brad
>
>
>
Received on Tue Sep 01 1998 - 10:43:34 CDT