Kbase P145366: Getting error 7512 when trying to select fields from a table using Crystal Reports 2008
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/08/2010 |
|
Status: Verified
SYMPTOM(s):
Getting error 7512 when trying to select fields from a table using Crystal Reports 2008
Access denied(Authorization failed) (7512)
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20228
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Access denied (Authorization failed) (7512)
User receives the same error when running code via a Sql Explorer connection to the database: sqlexp dbname -H hostname -S portnumber -user username
FACT(s) (Environment):
select * from sysprogress.sysdbauth; shows that root and SYSPROGRESS have DBA rights
Database does not have any users in the _User table.
The tables that the SELECT statement is being performed on is a 4GL table.
User does not want to create users in the _User table.
Progress 9.1E
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
The user does not have privileges to access the 4GL tables via the SQL92 engine.
FIX:
1) Open the SQL Explorer and connect as 'sysprogress' (no password) or the user account that created the database.
sqlexp dbname -H hostname -S portnumber -user (root or sysprogress)
2) Grant select privilege for the tables that the user would like to access via ODBC/JDBC:
grant select on pub.tablename to user;
commit;