Use this URL for searching for solutions on the progress website..
https://progress.primushosting.net/progress/esupport
For this issue that you have...
Progress Solution
ID: P20664
Title: "Error 7512 when connecting to a database using SQL92"
Created: 6-Mar-2003 Last Modified: 29-Nov-2004
Status: Verified
Known to occur in:
Progress 9.1A
Progress 9.1B
Symptom(s):
Access denied(Authorization failed) (7512)
[JDBC Progress Driver]:Access denied(Authorisation failed)
Error received trying to access database from ODBC or JDBC
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(s):
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).
Additional Information:
References to Written Documentation:
Progress Solutions:
20143, "Basic Guide to Defining Progress SQL-92 Database Permissions & Security