BUG: SQL Enterprise Manager Generates SQL-DMO Error for DBO Updating Permissions (229052)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q229052
BUG #: 54770 (SQLBUG_70)

SYMPTOMS

If a member of the db_owner role attempts to use SQL Server Enterprise Manager to modify database permissions, the following SQL Distributed Management Objects (SQL-DMO) error may be generated:
Error 22018: [SQL-DMO]You must be logged in as 'sa' or a member of sysadmin to perform this operation.

WORKAROUND

To work around this problem, use the Transact-SQL GRANT, REVOKE, and DENY statements to manipulate database permissions as desired.

STATUS

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

MORE INFORMATION

This problem is only encountered by members of the db_owner role when attempting to change database-level permissions using SQL Enterprise Manager. The problem does not affect the manipulation of object-level permissions within SQL Enterprise Manager. The following is a list of the database-level permissions affected:
  • Create Table
  • Create View
  • Create Stored Procedure
  • Create Default
  • Create Rule
  • Backup Database
  • Backup Log
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug KB229052
©2002 Microsoft Corporation. All rights reserved.