Row based security

From: Simon Worth (REMOVEFIRST_simon.worth_at_gmail.com)
Date: 03/11/05 

Date: Fri, 11 Mar 2005 08:22:43 -0700

I have a database system that contains 1 category of data.
There are plans in the future to add other categories of data as well.
Some users of the database can have access to 1 or more of the categories of
data, and other users can only have access to 1 category, and non of the
other categories of data.

I have a solution in place for row level security using stored procedures
and lookup tables to define what data can be viewed by what users.

In the Oracle world, row based security is handled, but in SQL Server there
is no mechanism in place within the security model to accommodate for it.

What are some approaches in SQL Server that others have used to accommodate
for Row level security issues? 

-- 
Simon Worth

Relevant Pages

  • Re: Row based security
    ... > "Simon Worth" wrote: ... >> I have a solution in place for row level security using stored ... >> In the Oracle world, row based security is handled, but in SQL Server ... >> is no mechanism in place within the security model to accommodate for ...
    (microsoft.public.sqlserver.security)
  • Re: Inactive record
    ... No there is no row level security based on SQL Server 2000. ... im Newsbeitrag news:eNTxiwzSFHA.612@TK2MSFTNGP12.phx.gbl... ... >> Software engineer. ...
    (microsoft.public.sqlserver.security)
  • SQL SEcurity
    ... How do I implement Row Level Security using SQL ... ANS2:There is a topic in SQL Server Books Online titled ... as "SQL Stored Procedures" within that topic it explains ... for all SQL statements in the procedure cache, ...
    (microsoft.public.sqlserver.security)
  • RE: Row based security
    ... Check this link for an approach on how do implement row level security in SQL ... "Simon Worth" wrote: ... > is no mechanism in place within the security model to accommodate for it. ...
    (microsoft.public.sqlserver.security)
Quantcast