The information in this article applies to:
BUG #: 52102 (SQLBUG_70) SYMPTOMSWhen 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. CAUSEThe 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:
-or-
STATUSMicrosoft has confirmed this to be a problem in SQL Server version 7.0. Additional query words:
Keywords : SSrvAdmin kbbug7.00 |
Last Reviewed: February 26, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |