HSQLDB : java.sql.SQLException: Access is denied in statement [SELECT * FROM TBALE]

This error appears when you have not specified required privileges to user in SCRIPT file for running the statements. Use the commands as follows just after user creation grant access as DBA like below:

CREATE USER SA PASSWORD ""
GRANT DBA TO SA

This entry was posted in Database, hsqldb, Java, Troubleshoot. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *