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.

Re: Hiding the Database list from a certain user/group

On Jun 18, 12:59 pm, OVDaddy 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.

Re: Hiding the Database list from a certain user/group

OVDaddy (dan@wemhoff.com) writes:
> On Jun 18, 12:59 pm, OVDaddy 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.

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/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Hiding the Database list from a certain user/group

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

Re: Hiding the Database list from a certain user/group

Plamen Ratchev (Plamen@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.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

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

Re: Hiding the Database list from a certain user/group

"Erland Sommarskog" wrote in message
news:Xns9954ECC668758Yazorman@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