Kbase P131488: SQL: Error:(7519) executing an SQL statement against SYSCALCTABLE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/14/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
SQL: Error:(7519) executing an SQL statement against SYSCALCTABLE
ERROR [42S02] [DataDirect][ODBC PROGRESS driver][PROGRESS]Table/View/Synonym not found (7519)
Executing the SQL statement:
REVOKE DELETE ON PUB.SYSCALCTABLE FROM PUBLIC;
CAUSE:
The error is generated because SYSPROGRESS is the owner of the SYSCALCTABLE table and not PUB. Indeed all the system tables whose names start with SYS are similarly owned by SYSPROGRESS and not by PUB.
FIX:
Specify the correct owner in the SQL statement. for example, the correct syntax of the above statement is:
REVOKE DELETE ON SYSPROGRESS.SYSCALCTABLE FROM PUBLIC