Re: public role???
From: Rob (rhchin@hotmail.com)
Date: 02/17/03
- Next message: Gino Reynoso: "DB Recovery"
- Previous message: BP Margolin: "Re: public role???"
- In reply to: BP Margolin: "Re: public role???"
- Next in thread: Jasper Smith: "Re: public role???"
- Reply: Jasper Smith: "Re: public role???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Rob" <rhchin@hotmail.com> Date: Mon, 17 Feb 2003 13:30:57 -0800
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: Gino Reynoso: "DB Recovery"
- Previous message: BP Margolin: "Re: public role???"
- In reply to: BP Margolin: "Re: public role???"
- Next in thread: Jasper Smith: "Re: public role???"
- Reply: Jasper Smith: "Re: public role???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
