Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

Syntax error in SQL statement with ErrorCode 210056 (10713)

« Go Back

Information

 
Article Number000086077
EnvironmentProduct: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Other: SQL Explorer
Question/Problem Description
SQL Explorer is returning an error when running the following statement:

GRANT SELECT ON pub._tablename TO 'username';

Error details are as follows:

=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210056
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "_tablename to 'username' " (10713)
Steps to ReproduceRunning the above statement in SQL Explorer.
Clarifying Information
Progress database is running fine and user is able to connect to it with SQL Explorer.
Error Message=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210056
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "_tablename to 'username' " (10713)
Defect/Enhancement Number
Cause
SQL syntax is unable to process an underline "_" as part of a table name.
Resolution
Enclose the table name in double quotes, as follows:

GRANT SELECT ON pub."_tablename" TO 'username';
Workaround
Another solution may be to use table names which don't contain any special characters.
Notes
Attachment 
Last Modified Date12/15/2017 6:22 PM