Microsoft KB Archive/270664

= PRB: Database Marked Read Only Does Not Allow You to Change User Permissions Simultaneously =

Article ID: 270664

Article Last Modified on 10/23/2000

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q270664



SYMPTOMS
In SQL Server Enterprise Manager (SEM), if a user database is marked Read-only, the database does not allow you to change user permissions simultaneously. The entire transaction in which the user tries to change the database status to Read-only, as well as the user permissions, should be rolled back. However, SQL Server saves the Read-only permissions for the database and does not save the Read-only permission for the user.



CAUSE
The various dialog boxes in SEM are run in order and are totally independent of each other. SQL Server does not allow any permission changes to any database user if the database has been marked Read-only. Setting the database to Read-only has the final authority, and any other changes made to the permissions of users on the database are rolled back.



WORKAROUND
This behavior is by design.

You will not be able to change user permissions in a database that has been marked Read-only.



MORE INFORMATION
Even though the Properties dialog box for the database shows that the database status has been changed to Read-only, the Read-only status is not implemented until you click the Apply button, and then close the Properties dialog box.

Additional query words: Read Only, Database, Enterprise Manager

Keywords: kbprb KB270664

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.