Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Hiding the Database list from a certain user\group

0 views
Skip to first unread message

OVDaddy

unread,
Jun 18, 2007, 12:59:41 PM6/18/07
to
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.

OVDaddy

unread,
Jun 18, 2007, 1:34:22 PM6/18/07
to
On Jun 18, 12:59 pm, OVDaddy <d...@wemhoff.com> wrote:
> 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.

Erland Sommarskog

unread,
Jun 18, 2007, 5:27:31 PM6/18/07
to
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, esq...@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Plamen Ratchev

unread,
Jun 18, 2007, 11:07:01 PM6/18/07
to
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

Erland Sommarskog

unread,
Jun 19, 2007, 5:14:17 PM6/19/07
to
Plamen Ratchev (Pla...@SQLStudio.com) writes:
> 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.

Plamen Ratchev

unread,
Jun 19, 2007, 6:18:59 PM6/19/07
to
"Erland Sommarskog" <esq...@sommarskog.se> wrote in message
news:Xns9954ECC66...@127.0.0.1...

>
> 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


0 new messages