| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Row Level Security Benefits?
Charlotte,
Didn't see/save your first email, but thought I'd point out that using Application Context features in conjunction with views is quite powerful and, to my knowledge, is available in Standard Edition. It can be used totally apart from FGAC. You're probably already aware of this, but I thought I'd mention it anyway.
Good luck.
Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)
Same-Day Stump Grinding! Senior Discounts!
"Rumpi Gravenstein" <rgravens_at_gmail.com>
Sent by: oracle-l-bounce_at_freelists.org
04/26/2007 03:12 PM
Please respond to
rgravens_at_gmail.com
To
charlottejanehammond_at_yahoo.com
cc
oracle-l_at_freelists.org
Subject
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
-- http://www.freelists.org/webpage/oracle-l -- Rumpi Gravenstein -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 26 2007 - 15:33:07 CDT
 |
 |