BUG: SEM Incorrectly Reports 4601 on Same-Named Objects

ID: Q152111

The information in this article applies to:

Microsoft SQL Server version 6.0

SYMPTOMS

When assigning permissions on an object you own, SQL Enterprise Manager (SEM) returns error 4601:

Only owner <%.*s> of object <%.*s>,in database %.*s can GRANT/REVOKE this permission.

This situation is transient and arises when multiple objects having the same name, but different owners, are created within a database while a connection to the server is active through SEM. The user logged on to the server through SEM must be one of the owners of the objects and must sort higher alphabetically than the other object owner. When SEM is used to modify the "By User" permissions for the object owned by the user logged on, error 4601 is reported.

WORKAROUND

SEM will properly assign permissions if the connection to the server is reestablished (Disconnect and expand the server to reconnect).

You can also use the Query Analyzer to execute the T-SQL commands to grant and revoke permissions.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: Enterprise Manager SEM permission

Keywords : kbbug6.00
Version : 6.0
Platform : WINDOWS
Issue type :