Database filtering

25 Oct 2006 8:02 PM

Mario Vasquez

Right now, when users connect to SSMS or Enterprise Manager, they can
see every database in the server. I'd like to have them see only those
databases which they have access to. At first, I thought I could use
filters as in database object with SMSS, but it seems like that doesn't
apply to the databases node.

I am looking for a way to make the SMSS/EM interface less cumbersome for
users who only need to manage a few database (2-3) out of hundreds in
the box. Any ideas?

Thanks in advance,
Mario Vasquez

25 Oct 2006 8:46 PM

Tibor Karaszi

For 2005, you don't see existence of objects that you don't have permissions on. But the one
exception to that is databases. Just use the VIEW DEFINITION permission for that. This is probably
granted at the database level to public.

For 2000, you are out of luck.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Mario Vasquez" <mario***@hotmail.com> wrote in message
news:uC7lyBH%23GHA.3860@TK2MSFTNGP02.phx.gbl...
> Right now, when users connect to SSMS or Enterprise Manager, they can see every database in the
> server. I'd like to have them see only those databases which they have access to. At first, I
> thought I could use filters as in database object with SMSS, but it seems like that doesn't apply
> to the databases node.
>
> I am looking for a way to make the SMSS/EM interface less cumbersome for users who only need to
> manage a few database (2-3) out of hundreds in the box. Any ideas?
>
> Thanks in advance,
> Mario Vasquez

25 Oct 2006 9:12 PM

Mario Vasquez

Tibor Karaszi wrote:

> For 2005, you don't see existence of objects that you don't have
> permissions on. But the one exception to that is databases. Just use the
> VIEW DEFINITION permission for that. This is probably granted at the
> database level to public.
>
> For 2000, you are out of luck.
>

Thanks Tibor,

Well, although I am using SMSS Express, unfortunately the server where
the databases are is a SQL Server 2000 :(

(sigh) I'll keep an eye on this...

Thanks again.