Kbase P14253: Error 7512 received querying a record using SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/29/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Error querying a record using SQL-92
Access Denied (Authorization failed)(7512)
[JDBC Progress Driver]:Access denied(Authorisation failed)
Not connected as sysprogress user
CAUSE:
The user connected does not have the appropriate permissions to access the table
FIX:
Use GRANT statement to grant the appropriate permission to the user.
Using SQL Explorer, connect to the database as a DBA user (sysprogress or other DBA).
Use the Grant statement to grant the permissions needed.
i.e. GRANT SELECT ON pub.customer TO 'bob';
or
GRANT SELECT ON pub."customer" TO 'bob';