Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Row Level Security


I am looking into row level security and found a good article:

Title: Implementing Row- and Cell-Level Security in Classified
Databases Using SQL Server 2005

URL: http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx

Is this still a good approach to take for a secure database? If not,
what would you recommend?

Are you aware of any sample project and DB that implements the above
approach?

Thanks

Hi,

as there is no row-level security bya default in SQL Server you will always
have to implement it for yourself. Implementation which I have seen
implemeted row level security (using the SUser_Name) with functions like
suser_Name() up to solution with passing hashes or certificates to SQL
Server. Row Level security is still an appropiate solution for making a
granular access to your data.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

<hufaun@yahoo.com> wrote in message

news:1173046321.597432.77820@n33g2000cwc.googlegroups.com...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc