Microsoft KB Archive/192963

= BUG: Msg 229 on UPDATETEXT If Source Table Lacks Permission =

Article ID: 192963

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q192963



BUG #: 17709 (SQLBUG_65)



SYMPTOMS
If you use the UPDATETEXT statement to update text data in a table on which you have appropriate update permission, based on a text column from another table on which you do not have update permission, it will fail with the following message:

Msg 229, Level 14, State 1

UPDATE permission denied on object %.*s, database %.*s, owner %.*s

The table listed in the message will be the table you are reading the information from.



WORKAROUND
To work around this problem, perform the following steps:


 * 1) Use SELECT..INTO to select data from the source table to a new table. You are the database owner (DBO) of this new table, and therefore have update permission on it.
 * 2) Read data from this new table. Get the textpointer from this table to do the update.



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

Additional query words: error err

Keywords: kbbug KB192963

-

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

© Microsoft Corporation. All rights reserved.