A user who is not a member of a required role can still connect to a SQL Server 2005 database after you set the user access option for the database to RESTRICTED_USER
The following pages were recently modified.
Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise Edition
KBA - A user who is not a member of a required role can still connect to a
SQL Server 2005 database after you set the user access option for the
database to RESTRICTED_USER