public role???

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


From: "Rob" <rhchin@hotmail.com>
Date: Mon, 17 Feb 2003 13:08:11 -0800


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.