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