Re: Row Level Security

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 07/25/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Thu, 25 Jul 2002 09:49:32 -0600

SQL Server doesn't support row level security directly so
you need to come up with your own methods through views,
stored procedures. How you do it really depends on a lot of
factors. This link gives an example of one approach to this:
http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm

-Sue

On Thu, 25 Jul 2002 08:17:23 -0700, "Marcos M Zorola"
<mzorola@saisd.net> wrote:

>What is the best method to implement row-level security on
>SQL Server 2000?

Relevant Pages

  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Securing Stored Procedures from being seen
    ... username, but in SQL Server, there are too many users to map an individuals ... granting the group execute permissions. ... but I would have to know what groups the user belongs ... see the names of any stored procedures to which he has no rights. ...
    (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: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7
    ... For parsing a string to a date/time, the 103 format doesn't limits the user ... > which is used as the row source for the results form). ... > other solutions assuming I have to use SQL Server 7? ... > I don't understand how I can use parameterized stored procedures to solve ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Limiting views on data in a table
    ... returns the Windows login the user uses to connect to SQL Server. ... > The way I was implementing this was to use Windows Auth with a Windows ... > covered by which salespeople, ... > with it via the stored procedures. ...
    (microsoft.public.sqlserver.security)