Solved

How to restrict a user to see only 1 database?

Posted on 2004-09-13
10
299 Views
Last Modified: 2012-05-05
Hi

We have an MS SQL server with different users. But when a user enters the enterprise manager then he can see the whole list of all databases created on that SQL server. That's not really the problem because he has only access to see the content of his database. But we have allready more then 40 databases on the SQL server and it takes up to 10 minutes to load that list. If the user only could see his database that it would reduce the load.

Can somebody advice me?

Thanks
0
Comment
Question by:combell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
10 Comments
 
LVL 6

Expert Comment

by:billy21
ID: 12043556
For each database
Right click on the database
Select 'Remove SQL Server Registration
0
 
LVL 6

Accepted Solution

by:
billy21 earned 43 total points
ID: 12043561
>Select 'Remove SQL Server Registration

Sorry that should be 'Delete SQL Server Registration'
0
 
LVL 9

Assisted Solution

by:solution46
solution46 earned 41 total points
ID: 12043706
Hmmm.. that would work if the problem was multiple servers, but I don't think it will work with multiple databases.

I dont think you can limit the list of databases on a server in Enterprise Manager (at least I've not found a way to do this).

So far as I can tell, you have two options...

1. Use EM but only open once at the beginning of the day...
2. Be a man - use Query Analyser!!! :)


s46.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 6

Expert Comment

by:billy21
ID: 12043727
AS long as each user has their own copy of enterprise manager installed it will work.  You can set up your own list.  Or are you saying we're looking at 1 server here and everybody shares the same instance of enterprise manager?
0
 
LVL 6

Expert Comment

by:billy21
ID: 12043765
Appologies Solution46 is right.  I was looking at servers and thinking databases ;-)
0
 
LVL 18

Assisted Solution

by:ShogunWade
ShogunWade earned 41 total points
ID: 12044649
EM is limited in its functionality in this respect.     Generall EM's performance is pretty poor because it uses SQLDMO.  

Ultimately EM and QA are developer and administratite tools so the concept of "But when a user enters the enterprise manager ...."   shouldnt exist.

As for 10mins.   I would suggest that this is either down to an inordinately busy network, v slow client or severely underpowered server.
0
 
LVL 9

Expert Comment

by:solution46
ID: 12326701
I wouldn't mind some of those points if they're being doled out. So far as I can tell we all said pretty much the same thing - don't do it!

s46.
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question