Re: Too many schemas!

From: Martin Doherty <martin.doherty_at_elcaro.moc>
Date: Mon, 18 Nov 2002 11:13:48 -0800
Message-ID: <W1bC9.7$IS4.60@news.oracle.com>

Oracle runs a free hosted service (sales.oracle.com and support.oracle.com) that uses VPD to host tens of thousands of subscribers in a small number of databases.

Martin Doherty

Karsten Farrell wrote:

> Sybrand Bakker wrote:
>
>> On 17 Nov 2002 04:30:41 -0800, donatella_at_webadorable.com (Donatella)
>> wrote:
>>
>>
>>> That would mean tagging ALL the records with client IDs which would
>>> predicate all data queries and transactions.
>>
>>
>>
>> That's why Oracle invented Fine Grained Access Control (available in
>> Enterprise Edition only). You can easily set up a policy for each
>> client which would transform *all* your queries, transparently,
>> without having to change anything.
>>
>> Regards
>>
>>
>> Sybrand Bakker, Senior Oracle DBA
>>
>> To reply remove -verwijderdit from my e-mail address
>
> You might also find Fine-Grained Access Control referred to in the
> docs as Row-Level Security (you use the DBMS_RLS package in your
> solution) or as Virtual Private Database (the current marketing term).
> If you do a Google search on any of these terms, you'll find others
> who have successfully implemented it.
>
Received on Mon Nov 18 2002 - 13:13:48 CST