[Libreoffice-bugs] [Bug 142158] New: External HyperSQL database is read-only when EDITING with non-DBA account

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142158

            Bug ID: 142158
           Summary: External HyperSQL database is read-only when EDITING
                    with non-DBA account
           Product: LibreOffice
           Version: 6.1 all versions
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ecthelion_ at web.de

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210507/0d605242/attachment.htm>