Re: Too many schemas!

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 17 Nov 2002 14:12:36 +0100
Message-ID: <3b5ftusqf663959igl8jq6s08jcpr2ekkn@4ax.com>

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 Received on Sun Nov 17 2002 - 07:12:36 CST