Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: What Sort of Privilege?

RE: Re[2]: What Sort of Privilege?

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 24 Aug 2004 09:47:54 -0400
Message-Id: <s12b0ed8.013@galottery.org>


The many schema method is easy to handle. The schema owner grants privileges to the dba with admin option
and the dba controls the roles. The schema owner/user can only "see" the tables that they own or are granted
access to. With many schemas sharing a few "common" tables from the majority( size wise) of the database, control and access is easy. We have 11 in house applications that have thier own schemas and 1 large warehouse type application on the database. No problems keeping everyone seperated.
Ron

>>> DGoulet_at_vicr.com 08/24/2004 9:12:00 AM >>>
Tom,

        Sorry, but you are wrong. I prefer the many schema method as well.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us]

Sent: Tuesday, August 24, 2004 8:21 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Re[2]: What Sort of Privilege?

Jo,

Well, The Oracle Apps applications have many schema's - much like what =
you
described.
I'm guessing that the majority of home-grown applications have only one
schema for all of the tables. I could be wrong. In my view, it is = easier
to manage. Everything is in one place. It prevents you from creating =
two
database objects with the same name. Managing security is easier - = again,
you can issue all your grants from one schema, rather than needing to =
keep
re-logging in.

Maybe it's just me!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: jo_holvoet_at_amis.com [mailto:jo_holvoet_at_amis.com]=20 Sent: Tuesday, August 24, 2004 8:13 AM
To: oracle-l_at_freelists.org
Cc: 'oracle-l_at_freelists.org'; oracle-l-bounce_at_freelists.org Subject: RE: Re[2]: What Sort of Privilege?

Hi Tom,

we (well, it was in place before I got here, but anyway) basically have=20
one schema per application. We also have one schema which houses = "common"=20
data, i.e. data used in many different places/apps; e.g. employees,=20 customers, products, plants, .... So we have many cross-schema FKs to =
the=20
"common" data but outside that everything is pretty well partitioned.=20
Maybe that's why I've never really had any problems with it.

Is having what is basically a one-schema database common practice ?

mvg/regards

Jo



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Aug 24 2004 - 08:44:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US