Kbase P20664: Error 7512 when connecting to a database using SQL92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/9/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
SYMPTOM(s):
Error (7512) when connecting to a database using a ODBC or JDBC client
Access denied(Authorization failed) (7512)
[JDBC Progress Driver]:Access denied(Authorisation failed)
User trying to connect to the database does not exist in _user table
User trying to connect to the database has not been created via CREATE USER statement
CAUSE:
The user does not have any privileges to access SQL-92 objects.
FIX:
1) Open the SQL Explorer and connect as 'sysprogress' (no password)
2) Grant DBA privilege to the desired user:
GRANT DBA TO 'user';
COMMIT;
The drawback is that anybody can use this user account (or sysprogress) in order to delete/modify any SQL92 objects (tables, indexes, ...) or modify the SQL92 privileges (creating new DBA user with password).