Kbase P186865: Cannot connect JDBC users other than root (the creator of the database) to the database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/30/2011 |
|
Status: Unverified
SYMPTOM(s):
Cannot connect JDBC users other than root (the creator of the database) to the database.
The errors being received:
Test failed because of the following error:
SE_Exception: The thread tried to read from or write to a virtual
address for which it does not have the appropriate access.
Error Executing Database Query. [DataDirect][OpenEdge JDBC Driver][OpenEdge]
Access denied (Authorization failed) (7512)
The error occurred on line 112.
No users listed in the _User table.
sysprogress.sysdbauth shows root and sysprogress.
sysprogress.systabauth does not show any other users.
FACT(s) (Environment):
Root can connect without errors.
Other users used to be able to connect to the database via JDBC but now they can't.
Linux
OpenEdge 10.1B
OpenEdge Category: Database
OpenEdge SQL Category: JDBC Drivers
CHANGE:
Database was dumped and loaded.
CAUSE:
Users were not migrated to the new database during the dump and load process.
FIX:
Create user accounts with passwords to the SQL Engine using the syntax mentioned in solution: 20413, "Basic Guide to Defining Progress SQL-92 Database Permissions & Security".