Re: Row Level Security Benefits?
- From: "Rumpi Gravenstein" <rgravens@xxxxxxxxx>
- To: charlottejanehammond@xxxxxxxxx
- Date: Thu, 26 Apr 2007 15:15:54 -0400
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@xxxxxxxxx> 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@xxxxxxxxx>
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
- Follow-Ups:
- Re: Row Level Security Benefits?
- From: JApplewhite
- References:
- Re: Row Level Security Benefits?
- From: Charlotte Hammond
Other related posts:
- » Row Level Security Benefits?
- » Re: Row Level Security Benefits?
- » Re: Row Level Security Benefits?
- » Re: Row Level Security Benefits?
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@xxxxxxxxx> 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
- Re: Row Level Security Benefits?
- From: JApplewhite
- Re: Row Level Security Benefits?
- From: Charlotte Hammond