Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mondeo
Constraint Violating Yak Guru
287 Posts |
 Posted - 2008-12-08 : 05:43:20
|
| Hi,I want to provide SQL 2005 databases on my server to several customers, (like a hosting company providing shared SQL hosting for example)I want to be clear about the security on it first, this is how I was planning on doing it. Can anyone advise if this is correct.1. Create server login for the customer2. Create database for the customer3. Create user in the database4. Associate the server login and user5. Add the user to db_owner roles and default schemaThanks |
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2008-12-08 : 06:54:50
|
| Thats the way I would do it.You can also use a seperate instance for each customer. This is more secure. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2008-12-08 : 07:16:31
|
| While a separate instance is more secure, it is also more difficult to administer and a significant drain on hardware resources. Plus there is a limit to the number of instances that can run on a single server. |
|
|
|
|
|
|
Providing secure shared SQL 2005 hosting