JDBC access - Authorization Failed.

[Boomn4x4]

I have a JDBC connection working to a remote test environment, and all is working fine. However, when I try to connect to a different local test system, I get the following error when trying to do a select:

java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Access denied (Authorization failed) (7512)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepareProcessReply(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepare(Unknown Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplStatement.prepare(Unknown Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplStatement.execute(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.executeQuery(Unknown Source)
at ProgressTest.main(ProgressTest.java:110)
Error: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Access denied (Authorization failed) (7512)

In my research, this is like because my database users doesn't have permission to select. However, when I go into my Progress Data Dictionary, all of my secuity settings are set to "*" to permit all access. How do I go about granting the appropriate authorization to my database to allow access?

 

[plowmafr]

Did anyone provide an answer to this post? I'm currently receiving the same error and can't identify the problem.

Thanks in advance.

 

[RealHeavyDude]

Did you configure SQL security on the Progress database?

Heavy Regards, RealHeavyDude.

 

[plowmafr]

The ODBC user didn't have JDBC priviledges to one of the tables. Thanks.