Re: public role???

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 02/17/03 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Mon, 17 Feb 2003 22:25:57 -0000

No. The guest user account cannot be removed from
either the master or tempdb database. 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rob" <rhchin@hotmail.com> wrote in message
news:063c01c2d6cb$db94ea70$2f01280a@phx.gbl...
> Thanks... you are absolutely correct. The guest user
> account existed for all these DBs. Any way to restrict
> these users from viewing the master and tempdb DBs as well?
>
> Thanks again.
>
> >-----Original Message-----
> >Rob,
> >
> >What exactly do you mean by "new users have access to all
> DBs"?
> >
> >If you mean that new users can see the names of the other
> databases, but not
> >actually get into them, then that's the way SQL Server
> works.
> >
> >If you mean that the new users can actually get into the
> other databases,
> >see if you have the "guest" account enabled in the other
> databases.
> >
> >Documentation on the "guest" account is available in the
> SQL Server Books
> >Online.
> >
> >-------------------------------------------
> >BP Margolin
> >Please reply only to the newsgroups.
> >When posting, inclusion of SQL (CREATE TABLE ...,
> INSERT ..., etc.) which
> >can be cut and pasted into Query Analyzer is appreciated.
> >
> >"Rob" <rhchin@hotmail.com> wrote in message
> >news:025401c2d6c8$adaa5620$a101280a@phx.gbl...
> >> Hello:
> >>
> >> I created a couple of new SQL Server users giving them
> >> access to a particular DB only. When I attempt to login
> >> for these new users via SQL Query Analyzer, I've noticed
> >> that the new users have access to all DBs.
> >>
> >> Is this because of the default 'public' role's
> >> permissions. If yes, then would the public role's
> >> permission of all other DB that I wouldn't want the
> users
> >> to have access to, need to be restricted?
> >>
> >> Your comments are highly appreciated. Thanks.
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: Joining tables from two databases
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... account with rights to both tables. ... to create a connection I need to use a connection ... Are these 2 databases are SQL Server? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Databases connections not working more with all web sites
    ... First check for permission problems. ... account for one of the sites with a problem to an account with administrator ... > Databases connections, both, for MS SQL Server 2000 and MS Access ...
    (microsoft.public.inetserver.asp.db)
  • Re: Joining tables from two databases
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I'm not really following how you are solving it using a service account. ... Are these 2 databases are SQL Server? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Why CAN I log in?
    ... Might be thru a GUEST user. ... The guest user account allows a login without a user account to access a ... > connecting to the SQL server and got a Test Successfully message. ...
    (microsoft.public.sqlserver.server)
  • Deny access to all users (including Administrator and DomainAdmins) except SA?
    ... How can I ensure that databases in a SQL Server instance are accessible (and ... manageable) ONLY through SA account or other accounts created by SA. ... Administrator or DomainAdmins of the box must be denied access to the DB. ... We ship SQL Server DB along with our product. ...
    (microsoft.public.sqlserver.security)