What does it mean by SQLState = 42000?

Asked Dec 04 '13 at 13:14

Active May 21 '19 at 15:18

Viewed 482 times

I am getting the following error when I try to start an integration in Tibco:

JDBC error reported: (SQLState = 42000) - com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: SELECT command denied to user '<user>'@'<server>' for table '<tablename>'

Is it because the user doesn't have SELECT query permission, or could it be another reason?

I'm asking here because the user has SELECT permission and still it throws this error.

edited May 21 '19 at 15:18

Mihai Chelaru

7,614
14
45
51

asked Dec 04 '13 at 13:14

Nevin Thomas

Thanks man. i dont have access to google, thats y i am not able to search it. thanks for quoting this answer for me. really help full. – Nevin Thomas Dec 04 '13 at 13:25
happy to help anytime :) – Tom Thomas Dec 04 '13 at 13:29

What does it mean by SQLState = 42000?

0 Answers0