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.
Dear Robert Großkopf, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Bug is still the same in Version: 25.8.3.2 (X86_64) Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded Deleting users will show the deleting in the dialog, but when saving and reopening it will show: Nothing has been changed. Adding users won't work also, rights for tables couldn't be edited.