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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-23 : 01:49:09
|
| Dan Johnson writes "We have a business requirement to exchange data with various vendors and give them dbo permissions to databases on our system that they maintain. While we are able to set a database and give them access to it and only it when they bring up enterprise and connect all our other databases are list with it in the MMC view. They do not have access to the additional databases but we really do not want them to know that they are even there. So, here is my question. Is there any way that SQL Server can be setup so that we can control what shows up in the MMC console view for certain users?ThanksDan Johnson" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-08-23 : 01:49:09
|
| Sorry, not that I've ever found. |
 |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-08-23 : 04:03:47
|
| Dan,If you are using SQL Server 2000, why not try an instance of SQL Server?Expose one instance to your client and your business works on the other....HTHDavidM"SQL-3 is an abomination.."Edited by - byrmol on 08/23/2002 04:05:03 |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-23 : 09:07:46
|
| The feature to hide databases in EM (or equivalent) for which the login has no user access is something that a lot have people asked for and so will hopefully make an appearance in Yukon.HTHJasper Smith |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-23 : 14:31:13
|
| You might be able to build a "replacement" for Enterprise Manager for them to use by using SQL-DMO (read Merkin's article to get started.)Then you can program it to show only the databases you want included. I don't have any immediate ideas how to keep them from using EM on their own, but it's a start... |
|
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-08-23 : 15:21:28
|
| Bymrol's suggestion seems excellent.What would you see as negatives in your particular situation? |
|
|
|
|
|
|
Giving limited access to our SQL Server to Vendors