Re: Column & Data specific security

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 08/02/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Fri, 2 Aug 2002 08:21:17 -0400

Create views on the tables with a WHERE clause that has their ID in it and
then give access to the views and not the tables directly. Or create sp's
that take a ID parameter and return the correct information. It's rarely a
good idea to give end users direct access to the underlying tables. 

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.
"Trent Henson" <trent.henson@blueink.net> wrote in message
news:e0g2TudOCHA.1796@tkmsftngp09...
> I have a need to limit the records viewed by a user on tables.  I have
> tables that contain data for multiple facilities and I would like to give
> the users direct READ access to the database but limit their queries by a
> specific facility ID.  The users will be running various third party
> reporting tools.  Any ideas on how to accomplish this?
>
>