Re: Project Organization within an Instance

Within the instance create a single user for each schema (project). That user is the only user that builds any object associated with the project.

Grant access to those objects to the other users each with their own user name. Do not let them build any objects using their name or it will be part of a separate schema. One person, and only one person, should have the ability to log on as the "project" and build objects.

Developers love to make messes. DBAs hate to clean them up. If you are the manager/DBA on this project run a tight ship and you will save yourself from a nightmare.

Daniel A. Morgan

Ken Chesak wrote:

> 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 Wed Apr 18 2001 - 00:27:42 CDT