RE: DESIGN suggestions needed.

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Wed, 27 Jun 2001 07:09:35 -0700
Message-ID: <F001.00339ED0.20010627070104@fatcity.com>

<SPAN

class=265215213-27062001>Andrey,
<SPAN

class=265215213-27062001> 
<SPAN

class=265215213-27062001>Perhaps 3 physical DBs are unnecessary.  Have you investigated Oracle8i's "Virtual Private Database" feature - AKA Fine-Grained Access Control or Row Level Security?  It allows you to guarantee that each User has access to only the data to which she has priviledges.  No views or complex application coding is required.
<SPAN

class=265215213-27062001> 
I
implemented this in a Web-enabled application last year.  It works very well.
<SPAN

class=265215213-27062001> 
<SPAN

class=265215213-27062001>See "Fine-Grained Access Control" in chapter 27 of "Oracle8i Concepts" for more info.
<SPAN

class=265215213-27062001> 
<SPAN

class=265215213-27062001>Jack

--------------------------------Jack C. 

ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.comjapplewhite_at_inetprofit.com(512)327-9068

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Andrey BronfinSent:   Wednesday, June 27, 2001 5:55 AMTo: Multiple recipients of list   ORACLE-LSubject: DESIGN suggestions needed.   Dear all !
  We have a client-server application which runs   agains one Oracle DB. Now , we've got a   requiremenet to split our DB into 3 databases  ( one for each country we   support - don't ask me why ) .
  So , we need to design it the way our existing   application will continue working , i.e. the "split" behind the scene will be   transparent to the application .
  I thought of creating 3 DB links to each one of the   databases for each object and then create a view : <FONT face=Arial   size=2>create view emp as select * from   emp_at_DB1 union all <FONT
  face=Arial size=2>select * from emp_at_DB2 <FONT face=Arial   size=2>union all select * from
  emp_at_DB3 ;
  But now the problem is with updates , inserts and   global relations ( i..e an employee in DB1 may belong to a department in DB3)   .
  did someone gone through a similar stuff ?   

  Please advice ! <FONT face=Arial
  size=2>thanks a lot in advance ! Received on Wed Jun 27 2001 - 09:09:35 CDT