February 15, 2002 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/ckempster/sqlserversecuritypart3.asp
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
February 18, 2002 at 10:58 am
Chris,
Great article. One question, what Oracle reference did you use? Row level security is an interesting topic, and one I've dealt with in a few places. I should probably write my own views down, but I like the work you did.
Steve Jones
February 18, 2002 at 3:54 pm
Well done article, nicely presented with reference material.
February 18, 2002 at 5:01 pm
Hi Steve
Check out technet.oracle.com, they have the books online etc as MSDN. I worked on a small project 1.5yrs ago with Oracles fine grained access control features and worked very well. The whole idea of the DB re-writing queries and appending a context string to the predicate is very powerful. The other technology was Oracle Labal security where it adds a new column to selected tables and applies a variety of security logic to your app in order to seemlessly implement RLS for existing apps.
Cheers
Chris.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy