Enterprise Manager and Master/temdb viewing

Hello,
Sorry for the simple question I am about to ask however I have not
found the answer elsewhere.
We have installed an SQL 200 box and are now about to grant users
access via Enterprise Manager. We have created logins for each user
with no Server Roles and access to their DB only. However when we
connect as this user through EM we can see Master and tempdb and view
the table information associated with theses DB's. We have removed
'guest' access from all other DB's. Is there any way to disable users
abilities to view the tempdb and master databases?
Thanks for your help.
CHi
Not with SQL Server 2000. This limitation is addressed in SQL Server 2005.
Everyone has rights to read sysdatabases and sysobjects.
Regards
Mike
"gg" wrote:
> Hello,
> Sorry for the simple question I am about to ask however I have not
> found the answer elsewhere.
> We have installed an SQL 200 box and are now about to grant users
> access via Enterprise Manager. We have created logins for each user
> with no Server Roles and access to their DB only. However when we
> connect as this user through EM we can see Master and tempdb and view
> the table information associated with theses DB's. We have removed
> 'guest' access from all other DB's. Is there any way to disable users
> abilities to view the tempdb and master databases?
> Thanks for your help.
> C
>|||Hi gg,
One of the thing you can do is, on the client machine, while you register
SQL server through EM, in the properties you can uncheck "Show system
database and system objects". This will prevent the client user from seeing
system database.
--
Thanks
Yogish