Re: Row based security

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

Date: Fri, 11 Mar 2005 11:58:11 -0700

Thanks Sue,
I've read that article before, and that's actually were I developed some
ideas from.
I was just wondering what others have done in the past, or are planning on
implementing in the future.
Just curiosity I guess. Plus, once in awhile you get an answer that really
makes sense that you hadn't thought of before. 

-- 
Simon Worth
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:0D4434BE-321E-4A38-87BF-2D08A238D35F@microsoft.com...
> Check this link for an approach on how do implement row level security in
SQL
> Server:
> http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm
>
> -Sue
>
> "Simon Worth" wrote:
>
> > 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: 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)
  • 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)
  • 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)
  • Row based security
    ... I have a database system that contains 1 category of data. ... I have a solution in place for row level security using stored procedures ... In the Oracle world, row based security is handled, but in SQL Server there ... What are some approaches in SQL Server that others have used to accommodate ...
    (microsoft.public.sqlserver.security)
Loading