Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Security Part 3 Expand / Collapse
Author
Message
Posted Friday, February 15, 2002 12:00 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1
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"
Post #2638
Posted Monday, February 18, 2002 10:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:56 PM
Points: 32,771, Visits: 14,935
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
steve@dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #28294
Posted Monday, February 18, 2002 3:54 PM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Today @ 3:54 PM
Points: 8,369, Visits: 733
Well done article, nicely presented with reference material.




Post #28295
Posted Monday, February 18, 2002 5:01 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1
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"
Post #28296
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse