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 - 12:57:11 CST