Enterprise manager

hi,i have a SQL server2000,there are some databases on the
server,what I try to achieve is to limit access of each
user. When they log into the server through "Enterprise
manager", they can only view their own database but not
all of them on the server.
thanksYou cannot limit the databases that a user sees through EM. If you want to
do this then you will have to roll your own using something like SQLDMO.
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"pfx" <panfx@.bizcn.com> wrote in message
news:007501c33f80$561e5ca0$a001280a@.phx.gbl...
> hi,i have a SQL server2000,there are some databases on the
> server,what I try to achieve is to limit access of each
> user. When they log into the server through "Enterprise
> manager", they can only view their own database but not
> all of them on the server.
> thanks