Project Organization within an Instance

From: Ken Chesak <ken.chesak_at_dhs.state.tx.us>
Date: Tue, 17 Apr 2001 09:51:52 -0500
Message-ID: <9bhlgd$nmo$1@goblin.tdh.state.tx.us>

I am new to Oracle and wondering how to organize a project within an instance. One instance would have many projects, each project would have many developers. Each project would typically reside within a single schema.

Example:

Instance - OracleDB

Schema - Project 1

Developers - A,B,C

All objects once completed should be part of schema Project 1.

Using alter session set current_schema = Project 1 works well keeping objects in one schema, but this requires the 'create any table...' permission which is too much access.

My background is Sybase, projects each have their own database.

Thanks Received on Tue Apr 17 2001 - 09:51:52 CDT