Kbase 35058: Error 7512 when querying Tables converted from Version 8 to 9
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/15/2000 |
|
Solution ID: P5058
FACT(s) (Environment):
Progress 9.x
Progress 8.x
SYMPTOM(s):
Error 7512 when querying Tables converted from Version 8 to 9
Access denied(Authorization failed) (7512)
Database converted using CONV89 utility
User that is querying the Table is the one running to CONV89 utility
CAUSE:
*Converted* databases have the sysprogress account as DBA. Unlike brand new V9 databases, the database creator does not have this privilege.
This is documented as RN#: 090B-00234 in the readme.pro file.
FIX:
1) Open the SQL Explorer and connect as 'sysprogress' (no password)
2) Grant DBA privilege to the database creator ('User ID'):
GRANT DBA TO '<user ID>';
COMMIT;
The drawback is that anybody can use this User ID (or sysprogress) in order to delete/modify any SQL92 objects (tables, indexes, ...) or modify the SQL92 privileges (creating new DBA user with password).
For security purposes it is recommended that the creation of the users 'sysprogress' and 'user ID') be done from within the Data Administration tool.