Kbase P103281: SQL-92 Error (7677) executing an SQL-92 UPDATE statement.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/04/2005 |
|
Status: Unverified
SYMPTOM(s):
SQL-92 Error (7677) executing an SQL-92 UPDATE statement.
Executing an SQL-92 UPDATE statement similar to:
UPDATE OrderLine
SET Qty = 12
WHERE Ordernum = 7 AND Linenum = 1;
CAUSE:
The UPDATE privilege on the specified table has not been GRANTed to the user executing the query.
FIX:
Use the SQL-92 GRANT statement to GRANT the UPDATE privilege on the specified table to the user executing the UPDATE statement:
GRANT UPDATE
ON OrderLine
TO username;
COMMIT;