| Author |
Topic |
|
jdev
Starting Member
4 Posts |
 Posted - 2004-07-29 : 07:21:38
|
| HelloI created a Login and gave that login rights in one of the dbs on my SQL Server. When I register a SQL Server in Enterprise Manager with this Login, it still can see all the other databases though it has no rights to access them. Is there a way to hide the databases a Login cannot access?Thank you |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-29 : 08:00:45
|
| No, I don't believe so. (For example, if you use a shared database at an ISP you will see all the databases, even though you have no access to them)Kristen |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-29 : 08:15:03
|
| Why do you care if it sees them? It has no way to access them at all.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jdev
Starting Member
4 Posts |
Posted - 2004-07-29 : 08:24:27
|
| Your right derrick but I have here just a bit a delicate situation where the user should not see the other dbs. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-29 : 08:27:15
|
| Can you not give them Enterprise Manager??? I don't think anyone should have Enterprise Manager anyway unless it's an administrator or an ISP situation. If it's that sensitive, you might want to look at another instance or server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jdev
Starting Member
4 Posts |
Posted - 2004-07-29 : 08:32:45
|
| You're right again. But no I cannot. The guy already has Enterprise Manager and he's going to access it remotely and it would things make even more complicated. I guess I have to live with the fact that he's going to see the other dbs. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-29 : 11:29:49
|
| FWIW I think this REALLY should be an option in EM. ISPs which offer shared SQL can take AGES to load in EM whilst all the DBs are discovered and listed. Doesn't make sense ... Let's hope Yukon improves this ...Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-29 : 14:39:01
|
| Yukon has improved this. Don't you read up on these things. :) It no longer waits to verify every freaking database and server when you login, which everyone should be extremely sad about (hahahaha).MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-29 : 14:49:28
|
"Don't you read up on these things."No, someone will be  Kristen |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-23 : 07:27:44
|
| hope this helps.i tried this before and it worked. it's just like disabling the enterprise manager. You need to restrict the public role. Experiment with each permission and see if that's what you need.Although, this will be set for everybody using the server except for sysadmins.The result, the user can only view objects using query analyzer and only the objects which he has permission to. |
|
|
|
|
Enterprise Manager Question