July 23, 2008 at 6:21 am
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
July 23, 2008 at 6:49 am
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....
July 23, 2008 at 6:53 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply