Click here to Skip to main content
15,891,184 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

Please Help Me to resolve my probelms

I have a LMS (Leads Mangement System) Panel for clients with different Domain where each domain have individuals database.
I want to all our clients login with a single domain (were all domain database connected with one domain ) but here problem is one how to user login with own unique id and password and get only own company data.

Ex: company name : abc and users id statrt with ABC001,ABC002....
company name : xyz and users id statrt with XYZ001,XYZ002....


Evere abc, and xyz is use same panel but it all have individuals data for own comapny .
I'm Working on ASP.NET & Web Development with Ado.net


Advance Thanks

What I have tried:

I'm Working on ASP.NET & Web Development with Ado.net
Posted
Updated 1-Dec-19 21:05pm
v2

1 solution

To do that you'd have to include a "selection filter" with each DB access from the client app:
SQL
... WHERE Company='Jones Marketing' AND ...;

That's a problem, because you are technically exposing one companies data to all companies in you deal with this at the client end: it isn't difficult to see the raw traffic and that you are specifically extracting client based data. Depending on what the data contains, you could easily fall foul of GDPR and the fines for "inappropriate" data can be considerable even if you don't directly reveal it yourself, as you are not taking due precautions to protect sensitive material.

You could do it at the server end: The client logs into to a server application which filters information specifically for the logged in user and cannot send any other data - and that's the only access route to the DB.

I'd rethink the whole design, if I was you ...
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900