Open a connection to an external Firebird file or a connection to Firebird server. Go to Tools → User-Administration. Try to change anything in "Access Rights for selected User". All rights seem to be set to "false", but this is wrong. I could access with the user to the tables, could modify all … Clicking on the check boxes does - nothing. Try to add a new user: Manage → Add user. A dialog appears for user name and password. Try to create - seems to accept all but no new user has been created. Tested also with other databases. When connecting to MariaDB with JDBC creating a user and deleting a user will work. Access rights will do the same as with Firebird. Direct connection to MariaDB and PostgreSQL gives this error. The database does not support user administration. at /home/buildslave/source/libo-core/dbaccess/source/ui/dlg/UserAdminDlg.cxx:94 So I can't find any database, which works well with this User-Administration. See discussion here: https://ask.libreoffice.org/t/unable-to-change-user-access-rights-with-lo-base-tools-user-adminstration-with-mariadb-when-logged-in-as-root/91247
Confirmed with firebird3.0-server (3.0.5.33220.ds4-1build2) on Ubuntu 20.04. I created a local database from isql, then connected to it with LO Base 7.5.3.2. I could not create a new user from Tools > User administration. Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
Just for the record, I fixed some bugs concerning Mysql/Mariadb part for User admin (see https://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=mariadb). About privileges, the pb is there are several layers of privileges (on database, on table, on column, see https://mariadb.com/kb/en/grant/) so don't know how to deal with all this.