Microsoft KB Archive/229052

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

Article ID: 229052

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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

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

Keywords: kbbug kbpending KB229052

-

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

© Microsoft Corporation. All rights reserved.