RE: RAC 10G for different companies with one shared database and label security
- From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
- To: <jg_dba@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 May 2007 15:27:37 -0400
Joop,
Why not different schema's instead of combining them. Would
make the day they decide to move on a lot easier. It's also a lot
easier to explain too, especially to auditors.
........................................................................
.............................................................
Kanbay
Dick Goulet, Senior Oracle DBA
45 Bartlett ST | Marlborough, MA 01752 USA
Tel: 508.573.1978 | Fax: 508.229.2019 | Cell: 508.742.5795
rgoulet@xxxxxxxxxx
........................................................................
.............................................................
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joop Gijsbers
Sent: Thursday, May 03, 2007 1:31 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RAC 10G for different companies with one shared database and
label security
hi all,
My company is asked to make a proposal for an ERP application for
several small business companies who uses this application.
the situation now is that those companies each have a single database
(9.2.0.8) on the same node.
In the new situation it will be be 1 or 2 10G release 2 RAC Clusters
with each one " shared" database. Oracle Label security must assure that
on row level the different companies can not use each other's data.
I am examining three questions:
- is Oracle Label Security an absolute, garantueed, method that
different companies using the same database/schema, not can see each
others data? My company has as far as i know no experience met Label
Security, so therefore is ask here for experiences;
- is there any argument for two clusters above one clusters with 2/3/4/n
instances?; i don't see them, concerning avalaibility, scalablity, or
other, but maybe i overlook something;
- can i use the the "services" concept in 10G RAC to force a bit of a
flexible way of loadbalancing (company A and B uses instance 1, coampany
C and D uses instance 2, company Eand F uses instance 3, etc.. and
flexible, that i can change that when company C uses more resources at
moment x...
Thanks,
Joop Gijsbers
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
