Re: public role???
From: BP Margolin (bpmargo@attglobal.net)
Date: 02/17/03
- Next message: Rob: "Re: public role???"
- Previous message: Rob: "public role???"
- In reply to: Rob: "public role???"
- Next in thread: Rob: "Re: public role???"
- Reply: Rob: "Re: public role???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "BP Margolin" <bpmargo@attglobal.net> Date: Mon, 17 Feb 2003 16:16:38 -0500
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: Rob: "Re: public role???"
- Previous message: Rob: "public role???"
- In reply to: Rob: "public role???"
- Next in thread: Rob: "Re: public role???"
- Reply: Rob: "Re: public role???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
