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

Dalke55 · Post by **Dalke55** » Thu Sep 15, 2022 6:48 pm

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.

Post by **UnklDonald418** » Thu Sep 15, 2022 7:04 pm

In the part of the statement
"INFORMATION_SCHEMA","SQL_IMPLEMENTATION_INFO"
replace the comma with a period.

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

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

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