Kbase P120636: Error 1436 accessing table in Oracle via Oracle data server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/11/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Oracle DataServer
SYMPTOM(s):
Error 1436 accessing table in Oracle via Oracle data server
Table or view does not exist or cannot be accessed. (1436)
The create statement errors out
The table was created by load delta sql file created by delta sql utility
The user is granted select and update permissions for the table
CAUSE:
The user is not granted permission for sequence of the table. When creating record in Oracle database, we increment sequence of the table.
FIX:
Grant select permission for sequence of the table