Kbase P63306: Error 7677 during execution of a grant update statement for
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/01/2004 |
|
Status: Unverified
FACT(s) (Environment):
Windows 32 Intel
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Using SQL-92 access to database
SQL trigger in record invokes sequence
Unable to access sequence inside SQL trigger
[JDBC Progress Driver]:permission denied (7677)
CHANGE:
Newly created database with data and schema from another v9 DB.
CAUSE:
The owner of the trigger is PUB and it is the owner of the trigger that requires proper authorization. The same is true for stored procedures. In this case the UPDATE privilege must be granted to PUB for the sequence.
FIX:
Grant UPDATE privilege to PUB for the sequence.