Bug 155183

Summary:	FIREBIRD: Dialog User Administration won't change anything with Firebird
Product:	LibreOffice	Reporter:	Robert Großkopf <robert>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	serval2412, stephane.guillou
Priority:	medium
Version:	7.5.3.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
URL:	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
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	104790

Description Robert Großkopf 2023-05-08 07:35:04 UTC

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

Comment 1 Stéphane Guillou (stragu) 2023-05-30 07:08:53 UTC

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

Comment 2 Julien Nabet 2023-12-03 15:51:20 UTC

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.