BUG: Permissions Not Changed Correctly Using SQL Enterprise Manager

• Microsoft SQL Server version 7.0

SYMPTOMS

Cycling through table permissions in the Object Properties dialog box in SQL Server Enterprise Manager (SEM), and using the Apply button to set a permission to DENY, actually sets the permission on the table to REVOKE.

WORKAROUND

To change the permission back to DENY:

1. In the Object Properties dialog box, click OK.



2. Re-open the Object Properties dialog box, and then click OK each time you change the permissions state.

STATUS

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

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug