Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Row Level Security in DW Star Schema

Re: Row Level Security in DW Star Schema

From: Steve Ritenour <ritenour_at_mediaone.net>
Date: Sat, 19 Feb 2000 04:53:10 GMT
Message-ID: <Wkpr4.1238$co6.61292@typhoon.mw.mediaone.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US