Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

For development/Application DBA's- Pls suggest , I need to filter data according to customer group(CustomerID) for each login Expand / Collapse
Author
Message
Posted Wednesday, July 23, 2008 6:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 9, 2011 8:12 PM
Points: 42, Visits: 188
We are using C#.net and SQL Server 2000. The data shown in application needs to be filtered according to the customer group. Now when the application is fully functional for years , making changes in joins (to include customerId,wherever misisng) in various SP's may not be feasible.

Can anyone pls suggest a workaround for the same so that for every login into application(concurrent sessions active) the users are able to see the data for their particular group only.

Thanks in advance.

Regards,
ansz5
Post #539175
Posted Wednesday, July 23, 2008 6:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:22 AM
Points: 1,310, Visits: 781
Hire a DBA / database architect?

Without knowing the structure of every table/query this needs done to, not much I can help you. But the general steps would be to identify where it all has to be done first, then individually look at all those stored procedures, views, functions, dynamic SQL code that needs it done. Could be a rough project depending on your code base....
Post #539207
Posted Wednesday, July 23, 2008 6:53 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,666, Visits: 5,316
You have two choices: Somehow figure out how to filter in C#.net or, bite the bullet and modify the stored procs. My opinion would favor modifying the stored procs. Script them out, use copy/paste to get the new join in there, where applicable. To me, the stored procs are responsible for passing the correct data to the presentation layer (.net). Simply my opinion.

Why would it not be feasible to modify the stored procs? Lack of experience in SQL? Lack of personnel? Or the shear number of procs? Just curious.

Edit - Watch which forum you post in (this is for SQL2005). Usually you'll receive quicker, more accurate answers by posting under the right platform....


-- You can't be late until you show up.
Post #539212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse