Re: new userID can do all...

From: Rob (
Date: 02/05/03

From: "Rob" <>
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" <> wrote in message
>> 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
>> data from his assigned DB. Thanks.