| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: What Sort of Privilege?
Ron,
Did you also take extra measures to keep everyone seperated from a performance point of view preventing one application influencing the performance of another application?
Jaco
(Embedded image moved to NL Telephone: +31 (0) 10 224 2045
file: pic23805.gif)Robeco E-mail: J.Polet_at_robeco.nl
Jaco Polet
Corporate ICT/BS DBA
"Ron Rogers"
<RROGERS_at_galottery To: <oracle-l_at_freelists.org>
.org> cc:
Sent by: Subject: RE: Re[2]: What Sort of Privilege?
oracle-l-bounce_at_fr
eelists.org
24-08-2004 15:47
Please respond to
oracle-l
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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: image/gif -- File: pic23805.gif ---------------------------------------------------------------- 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 Wed Aug 25 2004 - 02:15:59 CDT
 |
 |