Kbase P10716: SQL connections fail with authorization error after permissions have been granted on conv89 database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/12/2008 |
|
Status: Unverified
SYMPTOM(s):
SQL connections fail with authorization error after permissions have been granted on conv89 database.
User is unable to connect to database via SQL-Explorer
Error JDBC Progress Driver Access Denied Authorization failed
Error JDBC Progress Driver Access Denied Authorization failed
SQL Exception 1
SQL State=HY000
Error Code=-20228
JDBC Progress Driver Access Denied Authorization failed
Error JDBC Progress Driver Access Denied Authorization failed
FACT(s) (Environment):
Connecting to database with SQL Explorer
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge Category: Configuration
Adding the sysprogress user to the _user table will require logins to the database.
Problem does not occur a database that was converted via a dump and load.
Granted permissions to all tables for all users via SQL-92 engine.
CHANGE:
Added sysprogress to the _User table.
CHANGE:
Converted Database using the conv89 utility.
CAUSE:
When the _User table is not empty SQL-92 users will get Driver Access Denied errors if the user is not in the _user table.
FIX:
1. Add the sysprogress user to the _user table.
2. Connect to the database using sysprogress.
3. Grant permissions to the login names used by the users.
3. Remove the sysprogress user in the _User table.