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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Security question

Author  Topic 

obsoletedude
Starting Member

31 Posts

Posted - 2008-01-09 : 15:38:40
How can I prevent non SA's from being able to access my instances in SQL Management Studio? I have a number of databases and each database will have a unique user (non-sa). However, I would like to prevent that user from using the SQL login to Management Studio and seeing the other databases and/or logins.

Is this possible?

I would rather not have multiple instances as there may be a large number of databases.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-01-09 : 16:12:34
check this article out http://blogs.msdn.com/euanga/archive/2006/05/04/585513.aspx



-ec
Go to Top of Page
   

- Advertisement -