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

ID: Q229052

The information in this article applies to:

Microsoft SQL Server version 7.0

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 version 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

Additional query words: ent man entman SEM SSEM tsql sp st proc sproc db


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

Last Reviewed: April 19, 1999