Re: User can see and access Master and Northwind DB

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 10/16/02 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Wed, 16 Oct 2002 21:18:15 +0100

This is because of the guest user account in master and Northwind
You can remove it from Northwind if you want, however you cannot
remove it from the master database.

HTH
Jasper Smith

"Rodney" <rodney@cybersharks.net> wrote in message
news:45f901c27549$14835950$36ef2ecf@tkmsftngxa12...
> I'm new to SQL so here is my dilema. I created a DB in
> SQL and I have a single user logging in through a remote
> client into SQL. I want him only to see his DB and have
> rights to change only his DB. I've gone through all the
> steps of creating a user and giving him a role for the
> DB, but it seems he still can see the Master DB and
> Northwind DB. What is strange, all the DB's he is not
> able to view or change. He can also see my security
> settings and permissions. If anyone can shed some light
> on this or point me in the right direction, I would
> really appreciate it.

Relevant Pages

  • Re: stored proc question
    ... use northwind ... exec sp_test --returns 'master' ... > As I was implementing a sproc to one of my database, ...
    (microsoft.public.sqlserver.server)
  • Re: Creating System SPROC
    ... use northwind ... use pubs ... exec sp_test --returns 'master' ... exec sp_MS_marksystemobject sp_test ...
    (microsoft.public.sqlserver.programming)
  • Re: Deleting Model, MSDBData, Master Databases
    ... Unlike Northwind and Pubs, the three you mentioned are quite ... > Can I safely remove the model, msdbdata and/or the master ... > SQL7) without affecting the program operation and ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Opinions needed about the best "Middleware suite" kbmMW vs. RODA
    ... spend hours just first figuring out how does framework works, ... already using Chached Updates. ... I'm making heavy use of identity fields of sql server, ... What about master detail, where the primary field of the master record ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: XA installation instructions
    ... with the [SQLJDBCXAUser] role, you have to define the role in each database, ... SQL JDBC extended stored procedures which reside in master. ...
    (microsoft.public.sqlserver.jdbcdriver)
Quantcast