One database and multiple clients

Question

we are planning to develop product with on sql database so how can implement the security .

Customer would like to see their data and avoid to see other data . how can we achieve this 

Answer 1

Hi,

Create separate schema for different client and provide access to them.

---

Please click Mark As Answer if my post helped.
Thanks,
Senthill

Answer 2

On SQL Server 2016 and Azure SQL Database you can use Row-Level Security

Or, if you don't plan on having thousands of small customers, you can provision a separate database for each one.  Having the customers in separate databases has a number of real advantages beyond security (and the ability to assure each customer that their data is not co-mingled with data from other customers). 

You get per-customer backup and restore, per-customer patching and deployment, per-customer query plans, the option to scale out across multiple servers, simpler schema design, no need to build split/merge logic to extract customer data, etc.

David

---

David http://blogs.msdn.com/b/dbrowne/