Filter data based on user (MSSQL)

Just wondering if this is possible.

Say I have a table that hold data for clients in all 50 states (or the British equivalent:razz.

Can I set up a User in SQL Server such that the user only sees data from one state? As in allowing full access to the db but one a filtered subset of the data?

I believe you can do this with a 'view'. Then give that user access to execute the view.

<blockquote id="quote"><font size="1" face="geneva, verdana, arial" id="quote">quote:<hr height="1" noshade id="quote">Originally posted by catalyst

Just wondering if this is possible.

Say I have a table that hold data for clients in all 50 states (or the British equivalent:razz.
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
I thought Britain was now officially the 51st state?

Does that mean we can claim our share of the US national debt?

Yet another effort at taking posts 'off topic' by Mart there..

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

Canada is the 51st state, Britain comes in next.

Yeah, I know you can do it with a view, but I don't have control over the app that's pulling the data (compiled VB) and can't change the tables to views so I was looking for something security/user rights based.