Kbase P5058: Error 7512 when using SQL-92 to query tables in databases converted using CONV89 utility
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/18/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.x
Progress 9.x
SYMPTOM(s):
Database converted using CONV89 utility
Error when querying Tables using SQL-92 converted from Progress 8 to Progress 9
Access denied(Authorization failed) (7512)
CAUSE:
The user has not been granted access to the database tables via Sql-92
*Converted* databases have the sysprogress account as default DBA but the account is disabled
Unlike brand new Progress 9 databases, the database creator does not have SQL-92 privileges.
FIX:
1) Enable the sysprogress account within the Data Administration tool.
2) Open the SQL Explorer and connect as 'sysprogress'
3) Grant DBA privilege to the database creator or a designated user ('User ID'):
GRANT DBA TO 'user ID';
COMMIT;