Page 1 of 1

[Solved] 1: user lacks privilege or object not found: INFORMATION_SCHEMA.

Posted: Thu Sep 15, 2022 6:48 pm
by Dalke55
Attempted upgrade of haqldb.jar from 2.5 to 2.6.1. After running SQL code: SHUTDOWN SCRIPT and replacing the 2.5 hsqldb.jar with the 2.6.1 file opened SQL command and executed SELECT * FROM "INFORMATION_SCHEMA","SQL_IMPLEMENTATION_INFO" to verify; I received this status
1: user lacks privilege or object not found: INFORMATION_SCHEMA.

Can you give me some idea what I have to look for to resolve this?

AOO 4.1.13
My operating system is VMWare workstation 15.5.7 running Windows 10 64bit build 10.0.19043
Java 1.8.0_341

Thank You in advance.

Re: 1: user lacks privilege or object not found: INFORMATION_SCHEMA.

Posted: Thu Sep 15, 2022 7:04 pm
by UnklDonald418
In the part of the statement
"INFORMATION_SCHEMA","SQL_IMPLEMENTATION_INFO"
replace the comma with a period.