Re: Row Level Security Benefits?

Charlotte,

RLS gives you extra speed, flexibility and security. RLS policies are evaluated and then cached for the current session. That will speed queries up a little. RLS has some additional flexibility in that complicated business rules may more easily be expressed in directly PL/SQL. Finally with RLS there are no back-doors into your data as the security is placed directly on what is being secured.

With that said, if you have relatively simple requirements and are cash contrained, using views makes a lot of sense.

On 4/26/07, Charlotte Hammond <charlottejanehammond_at_yahoo.com> wrote:
>
> Hi All,
>
> I thought that I better clarify the "costs $$$s extra"
> is because we are on Standard Edition (10g) and would
> need to go to Enterprise Edition to get this feature.
>
> Charlotte
>
> --- Charlotte Hammond <charlottejanehammond_at_yahoo.com>
> wrote:
> It certainly costs $$$s
> > extra
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Rumpi Gravenstein

--
http://www.freelists.org/webpage/oracle-l