BUG: Msg 229 on UPDATETEXT If Source Table Lacks Permission (192963)
The information in this article applies to:
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:
- 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.
- 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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug KB192963 |
|---|
|