combell
asked on
How to restrict a user to see only 1 database?
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
Appologies Solution46 is right. I was looking at servers and thinking databases ;-)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
s46.
Right click on the database
Select 'Remove SQL Server Registration