Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Row Level Security in DW Star Schema
Thanks for the advice. Under 8.0.5 we had some PQO queries that were giving
us too many rows, maybe with 8.1.5 it will be a wash :).
P.S. Love the papers on your site. I've been a frequent visitor for a while.
Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:950858608.28810.1.nnrp-13.9e984b29_at_news.demon.co.uk...
>
> Test this very carefully with you application,
> in particular with the parallel query option
> (assuming you are planning to use it)
> and materialized views.
>
> With the PQ option data can simply
> disappear when RLS is involved; under
> materialized views some forms of
> RLS predicate will stop query rewrite
> from taking place.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Steve Ritenour wrote in message ...
> >I've answered my own question. Take a look at the dbms_rls package in
> >Oracle 8i EE. It allows you to define a function and attach it to a
table
> >or view as a security policy. Its pretty slick stuff, and best of all,
no
> >more views for row level security.
> >
> >Steve
>
>
>
Received on Fri Feb 18 2000 - 22:53:10 CST