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

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

Expand all | Collapse all

SYMPTOMS

A user who is not a member of a required role can still connect to a Microsoft SQL Server 2005 database after you set the user access option for the database to RESTRICTED_USER.

Consider the following scenario:

A user connects to a SQL Server 2005 database.
The user is not a member of the following roles:
- The db_owner fixed database role
- The dbcreator fixed database role
- The sysadmin fixed server role
You set the user access option for the database to RESTRICTED_USER.

In this scenario, the user who has already connected to the database can connect to the database again. This issue occurs even though the database is now set to refuse access to a user who is not a member of the previously listed roles.

Back to the top