Hiding the Database list from a certain user\group

Is there a way to limit what user will see in Enterprise Manager? I
would like them to only see there db's and not all them.On Jun 18, 12:59 pm, OVDaddy <d...@.wemhoff.comwrote:

Quote:

Originally Posted by

Is there a way to limit what user will see in Enterprise Manager? I
would like them to only see there db's and not all them.

I have read and see that I am not able to do this.|||OVDaddy (dan@.wemhoff.com) writes:

Quote:

Originally Posted by

On Jun 18, 12:59 pm, OVDaddy <d...@.wemhoff.comwrote:

Quote:

Originally Posted by

>Is there a way to limit what user will see in Enterprise Manager? I
>would like them to only see there db's and not all them.

>
I have read and see that I am not able to do this.

I believe that in EM, you will see only the databases you have access to.

In SQL Server Management Studio that comes with SQL 2005, it's a different
story. Here you cannot hide databases.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||By default users see all databases in Enterprise Manager. The following KB
shows a method that you can use so users can see only databases that they
have access to (the title of the article is a bit off topic but in fact it
does show a good method):
http://support.microsoft.com/default.aspx/kb/889696
For SQL Server Management Studio this is much easier, you can just deny a
login the VIEW ANY DATABASE permission and that will do it.

HTH,

Plamen Ratchev
http://www.SQLStudio.com|||Plamen Ratchev (Plamen@.SQLStudio.com) writes:

Quote:

Originally Posted by

For SQL Server Management Studio this is much easier, you can just deny a
login the VIEW ANY DATABASE permission and that will do it.

Arguably. The users will only see the databases they *own*. They could
have access to other databases, but they will not show up.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
news:Xns9954ECC668758Yazorman@.127.0.0.1...

Quote:

Originally Posted by

>
Arguably. The users will only see the databases they *own*. They could
have access to other databases, but they will not show up.
>

Yes, but my understanding of the original post is that it asked for
configuration where users can see only their own databases, so this applies
here. This is what I meant. :)

Plamen Ratchev
http://www.SQLStudio.com