Bug 142158 - External HyperSQL database is read-only when EDITING with non-DBA account
Summary: External HyperSQL database is read-only when EDITING with non-DBA account
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1 all versions
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: QA:needsComment
Keywords:
Depends on:
Blocks:
 
Reported: 2021-05-07 16:04 UTC by ecthelion_
Modified: 2021-05-22 04:24 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.