Re: public role???
From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 02/17/03
- Next message: Jasper Smith: "Re: DB Recovery"
- Previous message: Tom: "logon failed"
- In reply to: Rob: "Re: public role???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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. > >> > > > > > >. > >
- Next message: Jasper Smith: "Re: DB Recovery"
- Previous message: Tom: "logon failed"
- In reply to: Rob: "Re: public role???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
