Bug 142158

Summary: External HyperSQL database is read-only when EDITING with non-DBA account
Product: LibreOffice Reporter: ecthelion_
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: UNCONFIRMED ---    
Severity: normal    
Priority: medium    
Version: 6.1 all versions   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard: QA:needsComment
Crash report or crash signature: Regression By:

Description ecthelion_ 2021-05-07 16:04:21 UTC 
Problem description:
When accessing an external stand-alone HyperSQL database via LO Base with a user account lacking the DBA role, tables are read-only in the GUI even if appropriate privileges have been granted to the user.

Steps to reproduce:
1. Create a stand-alone HSQLDB database outside of LibreOffice (e. g. with the default org.hsqldb.util.DatabaseManagerSwing).
2. Create a cached table and insert some test data.
3. Create a non-DBA role and grant it select, delete, insert and update privileges on the table.
4. Create new user and assign the role to him.
5. Shutdown the database and close the connection.
6. Open Database Wizard and connect to existing database via JDBC with database URL jdbc:hsqldb:file:<path to db>;shutdown=true;default_schema=true and credentials of the non-DBA user.
7. Open the table in the Data Table View.

Current behavior: Table is read-only.

Expected behavior: Table entries can be altered according to assigned privileges.

Note: When opening the table in table design view, no columns are shown there and the table cannot be altered. When removing default_schema=true from the database URL or accessing the database with SQL via "Execute SQL Statement", Base behaves as expected.

Bug also appears in Version 7.1.2 on Windows 8.1 (x86-64). I am using HSQLDB 2.6.0.