Master database can be browsed by any user. is this normal?

From: John Dalberg (john_dd_at_hotmail.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 13:13:07 -0700

I created a sql server type user who has access to a single database which
I created. When I logged in as the user, I was able to browser and read the
Master database tables even though there's no login user in the Master
database for that user. Is this normal behavior?

John

Relevant Pages

  • Re: Cluster will not fail over.
    ... Senior Database Administrator ... >> As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... >> able to restore the master database. ... >> a cluster installation you'll have to revisit. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cross database granting
    ... connection will default to the master database. ... You could enable cross database chaining ownership (whatever it is called, ... > Chris Buys ... >>> the EXECUTE priviledge. ...
    (microsoft.public.sqlserver.programming)
  • Re: Trigger, alternative way to pass variable to trigger
    ... You don't have to execute the setUser command in the master database, ... create trigger trigger name ... to call stored procedure or execute sql commands and let it handle it the ... Pro SQL Server 2000 Database Design ...
    (microsoft.public.sqlserver.programming)
  • Re: Cross database granting
    ... When I login as sa, ... > connection will default to the master database. ... > xp_cmdshell implicitly if called from a proc in the app database. ...
    (microsoft.public.sqlserver.programming)
  • RE: Refering Local DB Tables from Master Procedures
    ... Is there any way I can directly query user tables just like system tables, ... >> the master database. ... >> I granted public access to this procedure in the master database. ... >> records from syscolumn tables of that local database, ...
    (microsoft.public.sqlserver.server)