Showing posts with label paper. Show all posts
Showing posts with label paper. Show all posts

Tuesday, March 20, 2012

Row Level Security Expressions in Yukon

Has row level security expressions made it into Yukon or has it been dropped
? I see its in the white paper but was wondering if it looks like it will ma
ke it at this point in the beta? No I wasn't invited to the beta so I can't
post to that newsgroup. Tha
nks!I can't really discuss what features are in or out of Yukon.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Friday, March 9, 2012

Row and cell level security

A doctoral student of mine would like to know how he can get in contact
with the authors of the interesting white paper "Implementing Row and
Cell Level Security in Classified Databases Using SQL Server 2005"
Published: April 1, 2005 By Art Rask, Don Rubin, and Bill Neumann,
Microsoft Consulting Services.
Dr. Bo Sanden, Ph.D.
Prof. of Computer Science
Colorado Technical University
Colorado Springs, CO 80907Hi,
hop its correct :
art.rask@.tpi.net
source of information (google search)
http://www.uga.edu/~spc/Undergrad/s...n3700fall05.pdf
http://blogs.msdn.com/federaldev/ar.../19/471595.aspx
http://www.tpi.net/about/selectedAdvisor.aspx?ID=153
HTH
Regards
Andy Davis
Activecrypt Team
---SQL Server Encryption Software
http://www.activecrypt.com
"Bo Sanden" wrote:

> A doctoral student of mine would like to know how he can get in contact
> with the authors of the interesting white paper "Implementing Row and
> Cell Level Security in Classified Databases Using SQL Server 2005"
> Published: April 1, 2005 By Art Rask, Don Rubin, and Bill Neumann,
> Microsoft Consulting Services.
>
> Dr. Bo Sanden, Ph.D.
> Prof. of Computer Science
> Colorado Technical University
> Colorado Springs, CO 80907
>|||Thanks, Andy.
Bo
Andy Davis wrote:
> Hi,
> hop its correct :
> art.rask@.tpi.net
> source of information (google search)
> http://www.uga.edu/~spc/Undergrad/s...n3700fall05.pdf
> http://blogs.msdn.com/federaldev/ar.../19/471595.aspx
> http://www.tpi.net/about/selectedAdvisor.aspx?ID=153
>
> HTH
> Regards
>|||For a well documented, alternative approach for row level security
implementations please see http://www.technicalmedia.com (Data Nomad
product). Please feel free to contact me through the feedback page on the
site.
Row-Level Security for Microsoft SQL Server 2005
----
--
Data Nomad? is an affordable set of developer tools that extend the
Microsoft SQL Server 2005 platform to provide row-level security and remote
access features allowing developers to accurately and efficiently create and
manage powerful distributed applications that insure access to information i
s
protected.
Developers of .NET 1.1 and .NET 2.0 smart client and web applications can
now easily add row-level security to database applications through the Data
Nomad? developer tools. Existing databases are easily configured by
identifying the tables to be protected and by creating row-level permission
grants.
The same (unmodified) SQL statements work against the Nomad database
extensions. The extended database appears to only contain the rows to which
the user has at least read permissions. Database updates and deletes only
succeed against rows to which the user has owner permissions.
This type of seamless integration is achieved by leveraging two powerful new
features of Microsoft SQL Server 2005: the schema (a collection of database
objects that form a single namespace) and the synonym (an alternative name
for another database object providing a layer of abstraction over the
original object).
The Nomad extensions support both SQL Server authentication and Integrated
NT authentication for database connections, and support local, LAN-connected
,
and Web-connected backend databases.
"Bo Sanden" wrote:

> A doctoral student of mine would like to know how he can get in contact
> with the authors of the interesting white paper "Implementing Row and
> Cell Level Security in Classified Databases Using SQL Server 2005"
> Published: April 1, 2005 By Art Rask, Don Rubin, and Bill Neumann,
> Microsoft Consulting Services.
>
> Dr. Bo Sanden, Ph.D.
> Prof. of Computer Science
> Colorado Technical University
> Colorado Springs, CO 80907
>