Re: new userID can do all...

From: Rob (rhchin@hotmail.com)
Date: 02/05/03


From: "Rob" <rhchin@hotmail.com>
Date: Wed, 5 Feb 2003 13:51:40 -0800


No server roles have been assigned. Thanks.

>-----Original Message-----
>What Server Roles did you give him?
>
>--
>Denny Cherry
>Database Administrator
>GameSpy Industries
>
>"Rob" <rhchin@hotmail.com> wrote in message
>news:093501c2cd5b$f4096690$cef82ecf@TK2MSFTNGXA08...
>> On a new install of SQL Server 2000, I created a user
>> giving him access only to one certain DB with
>> db_datareader DB role assigned to him.
>>
>> While testing using his userID, I see that the user is
>> allowed not only to view other DBs but also update them.
>>
>> How can I restrict this user's ID to only be able to
view
>> data from his assigned DB. Thanks.
>
>
>.
>