Re: Restricting rows

From: BP Margolin (bpmargo@attglobal.net)
Date: 08/29/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Wed, 28 Aug 2002 20:23:46 -0400

Shawn,

DENYs apply to the entire table and not to a subset of the table.

Is there any chance that you can just replace SELECTs with calls to a stored
procedure, and incorporate the logic within that?

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Shawn Barrow" <sbarrow@cfoconsult.com> wrote in message
news:a52201c24edb$599bc3e0$a4e62ecf@tkmsftngxa06...
> Is there a way to DENY the SELECT permission on just
> certain rows in a table. For example, I need to restrict
> a user from selecting rows from a table where a certain
> column is set to a certain value. A view will not work
> due to the way external applications connect to the DB.