Microsoft KB Archive/231403

= BUG: BOL incorrectly states that a member of db_owner role can issue SETUSER command =

Article ID: 231403

Article Last Modified on 7/31/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q231403



BUG #:55519 (SQLBUG_70), 56942 (SQLBUG_70), 216526 (SHILOH_BUGS)



SYMPTOMS
The following sections in SQL Server 7.0 and SQL Server 2000 Books Online incorrectly state that a member of the db_owner role can issue the SETUSER command:
 * SETUSER (TSQL)

The first sentence in the Remarks section incorrectly references db_owner.

Note This problem is resolved in the SQL Server Books Online January 2004 Update.
 * GRANT (TSQL)

The second table incorrectly contains a row for SETUSER.

Note This problem is resolved in the SQL Server Books Online January 2004 Update.
 * UserName Property (SQL-DMO)

The Remarks section incorrectly references db_owner.

In addition, the Permissions paragraph in the SETUSER (TSQL) section of SQL Server 7.0 Books Online incorrectly references db_owner.



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

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



MORE INFORMATION
SETUSER permission is given only to members of the sysadmin role; this permission is not transferable.

When a member of the db_owner role executes the SETUSER command, the statement correctly fails with the following error message:

Server: Msg 262, Level 14, State 3, Line 1

SETUSER permission denied, database 'TestDB', owner 'dbo'.

IMPORTANT: SETUSER is included in SQL Server 7.0 and SQL Server 2000 for backward compatibility only; its usage is not recommended.

