BUG: User's Role Not Updated Instantly in Multiple Sessions

• Microsoft SQL Server version 7.0

SYMPTOMS

When adding a user to a fixed role, such as db_owner or db_securityadmin, the user's role is not updated immediately in other sessions if the user is logged in with multiple sessions. This behavior is not seen in the case of user-defined roles. In that case, the user's role is updated immediately in all the sessions that the user is logged in.

CAUSE

The security cache is not updated with fixed role membership bits until the next time the database is used (internally) or the cache is rebuilt for some other reason (for example, checking select permissions).

WORKAROUND

To work around this problem, force the security cache to update the fixed role membership bits by executing statements like the following:

use <db_name> 

select is_member ('<fixed role>') 

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords          : SSrvAdmin kbbug7.00 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: February 26, 1999