Information

Title	Error 7512 when connecting to a database using SQL92

URL Name	P20664

Article Number	000135646

Environment	Product: Progress Version: 9.1x Product: OpenEdge Version: All Supported Versions OS: All supported platforms Other: SQL92

Question/Problem Description

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

Steps to Reproduce

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

The user does not have any privileges to access SQL-92 objects.

Resolution

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).

Workaround

Notes

References to Written Documentation:

Progress Solutions:
Basic Guide to Defining Progress SQL-92 Database Permissions & Security

Keyword Phrase

Last Modified Date	10/12/2020 5:15 PM

Error 7512 when connecting to a database using SQL92

Information