Kbase P7290: Can't access orignal 4GL table in a converted database via S
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/01/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Accessing tables via SQL92 ODBC connection
Can't see original 4GL tables in converted database
Can see newly created 4GL tables
Progress security is enabled with one userid
CHANGE:
Database converted using conv89 utility
CAUSE:
Newly created tables were created by the one user. Therefore, that user has access, as creator of the tables, to these tables via ODBC. The other tables are owned by PUB. The user does not have permissions to these tables.
FIX:
In the case of converted databases, SYSPROGRESS is the defined DBA. Create SYSPROGRESS user in the _user table. Login as SYSPROGRESS via ODBC and grant the necessary priveledges to the one user.