Posted by Erland Sommarskog on 06/18/07 21:27

OVDaddy (dan@wemhoff.com) writes:
> 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.

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

• Next in forum: Re: mdac 2.8 and sql 2005 cursor performace issue
• Prev in forum: Re: Help with database design.
• Thread view: Re: Hiding the Database list from a certain user\group

[Reply to this message]