How to restrict access to a sql server database from Azure?

Restrict SQL Server Login access to only one database

I have a SQL Server server which has around 50 databases on it. I wish to create a new Login for a client who wishes to have access to their database. But I don't want to give them access to the other ~49 databases. How can I do this? Cheers.
Answer:

Connect to your SQL server instance using management studio Goto Security -> Logins -> (RIGHT CLICK) New Login fill in user details Under User Mapping, select the databases you want the user to be able to access and configure UPDATE: you'll also want to goto Security -> Server Roles, and for "public" check the permissions for TSQL Default TCP/TSQL Default VIA/TSQL Local Machine/TSQL Named Pipes and remove the "connect" permission

Curt at Stack Overflow Visit the source

Was this solution helpful to you?

Related Q & A:

Can I create a second filestream container on an existing SQL Server 2008 database without going offline?Best solution by Database Administrators
How to connect Sql Server Database from android app?Best solution by Stack Overflow
What is the best practice for free space for a SQL server database drive?Best solution by Database Administrators
How to Restrict Database for One User in SQL Server 2008 R2?Best solution by Database Administrators
How to import XML into SQL Server database?Best solution by Stack Overflow

Just Added Q & A:

How many active mobile subscribers are there in China?Best solution by Quora
How to find the right vacation?Best solution by bookit.com
How To Make Your Own Primer?Best solution by thekrazycouponlady.com
How do you get the domain & range?Best solution by ChaCha
How do you open pop up blockers?Best solution by Yahoo! Answers

For every problem there is a solution! Proved by Solucija.

Got an issue and looking for advice?
Ask Solucija to search every corner of the Web for help.
Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.