Need to filter data on the basis of group to which the application user belongs to.

• ansz5

  Ten Centuries

  Points: 1282

  More actions

  July 23, 2008 at 5:47 am

  #191395

  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

• Daryl AZ

  Hall of Fame

  Points: 3087

  More actions

  July 23, 2008 at 9:30 am

  #847144

  If you are fortunate enough to have a Data Layer this change may be less painful.

  1- update sprocs with addition criteria 'group' (defaults to All, or not filtering)

  2- at the datalayer add a function that checks the logon and determines which group to pass to SQL sprocs.

  If you are not filtering at the database you can only filter at the app level (inefficient) and still requires coding changes.

  You may also need to have additional table/s for which group/s have access to which projects/customers/other/?.