This is a discussion on "Filter data based on user (MSSQL)" within the Databases section. This forum, and the thread "Filter data based on user (MSSQL) are both part of the Program Your Website category.
|
|
|
|
|
 |
||
Filter data based on user (MSSQL)
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
Sep 18th, 2003, 02:16
|
|||
|
|||
|
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? |
|
|
|
Sep 18th, 2003, 08:00
|
|||
|
|||
|
I believe you can do this with a 'view'. Then give that user access to execute the view.
|
|
Sep 18th, 2003, 12:15
|
|||
|
|||
|
<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? |
|
Sep 18th, 2003, 17:29
|
||||
|
||||
|
Yet another effort at taking posts 'off topic' by Mart there..
__________________
Rob - SEO Specialist Owner & Founder of Webforumz.com I am currently unavailable for private work
Last Blog Entry: Creative Labs threaten developer over home made drivers.... (Apr 1st, 2008)
|
|
Sep 19th, 2003, 05:48
|
|||
|
|||
|
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. |
|
| Tags |
| filter, data, based, user, mssql |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Redirect user based on location | bean_2k1 | PHP Forum | 2 | Apr 22nd, 2008 09:47 |
| mysql data loads once user login | longstand | PHP Forum | 9 | Feb 7th, 2008 07:10 |
| [SOLVED] Dispaly User Data Once Logged In | longstand | PHP Forum | 2 | Nov 21st, 2007 20:16 |
| can't convert table-based to css-based layout | markus | Web Page Design | 21 | Apr 25th, 2007 22:50 |
| [SOLVED] MySQL to MSSQL | Anonymous User | Databases | 7 | Oct 6th, 2003 07:48 |
