Kbase P93769: Using quotes around schema and table name in SQL query may return error "Access denied" when using a
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/27/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.0x
OpenEdge 10.1A
SYMPTOM(s):
Using quotes around schema and table name in SQL query returns error Access denied
[JDBC Progress Driver]:Access denied (Authorization failed) (7512)
[ODBC Progress Driver]:Access denied (Authorization failed) (7512)
SELECT * from "pub"."customer"
User is PUB
CAUSE:
This is a known issue being investigated by Development
FIX:
There are three workarounds for this issue:
1. To GRANT SELECT privileges to the PUB user.
2. Remove the quotes from the table name in the FROM clause.
3. Put the schema and table name in uppercase
E.g. "PUB"."CUSTOMER"