Keep users from view other databases

Hi,
We are a small ISP that allows user to use Enterprise Manager to work with
their databases. We would like the users to only see that databases they hav
e
permissions for. The way SQL 200 is setup by default the users can see all
the databases on the server.
So the question is can we change something that would prevent users from
seeing the other databases on the server?
Thanks in advance,
BobNot with Enterprise Manager and SQL 2000. The users will be
able to see the other databases. They can't access them
without the appropriate permissions but they will be able to
see them.
-Sue
On Mon, 28 Feb 2005 16:57:03 -0800, "Bob Melani" <Bob
Melani@.discussions.microsoft.com> wrote:

>Hi,
>
>We are a small ISP that allows user to use Enterprise Manager to work with
>their databases. We would like the users to only see that databases they ha
ve
>permissions for. The way SQL 200 is setup by default the users can see all
>the databases on the server.
>So the question is can we change something that would prevent users from
>seeing the other databases on the server?
>Thanks in advance,
>Bob|||Bummer,
Thanks for the answer..
"Sue Hoegemeier" wrote:

> Not with Enterprise Manager and SQL 2000. The users will be
> able to see the other databases. They can't access them
> without the appropriate permissions but they will be able to
> see them.
> -Sue
> On Mon, 28 Feb 2005 16:57:03 -0800, "Bob Melani" <Bob
> Melani@.discussions.microsoft.com> wrote:
>
>