[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #22 from prrv...@gmail.com --- I have just finished an implementation in Base of the management of roles and users of the underlying database. https://prrvchr.github.io/jdbcDriverOOo/#libreofficeopenoffice-base-improvement This has only been tested with HsqlDB, malfunctions are to be expected with H2 and Derby or any other JDBC driver, this remains to be tested... Voila, I hope this can be useful... -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #21 from Robert Großkopf --- (In reply to Alex Thurgood from comment #20) > > To follow on from my last post, if I look at what's available for mysql, for > example: > > core/connectivity/source/drivers/mysqlc/mysqlc_user.cxx > > it seems that pretty much any and all user/privilege/role functionality > requires implementation, as pointed out in the stubs in the code. But: The database does not support user administration. at /home/buildslave/source/libo-core/dbaccess/source/ui/dlg/UserAdminDlg.cxx:94 This message appears with direct connection to MariaDB. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #20 from Alex Thurgood --- (In reply to Alex Thurgood from comment #19) To follow on from my last post, if I look at what's available for mysql, for example: core/connectivity/source/drivers/mysqlc/mysqlc_user.cxx it seems that pretty much any and all user/privilege/role functionality requires implementation, as pointed out in the stubs in the code. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #19 from Alex Thurgood --- (In reply to prrvchr from comment #18) > If we want to solve this problem, does anyone have information concerning: > - How to add a menu entry in Base under User Administration. > - How to find the connection in the protocol handler which will manage this > new url. I see something for hsqldb, here: core/connectivity/source/drivers/hsqldb/HUser.cxx core/connectivity/source/drivers/hsqldb/HUsers.cxx might be the place to start, to try and understand. Presumably, this would have to be implemented/adapted for each of the supported drivers in their respective areas. For the UI part, the UserAdmin dialog seems to be defined here: https://github.com/LibreOffice/core/blob/master/dbaccess/uiconfig/ui/useradminpage.ui and possibly in part here: https://github.com/LibreOffice/core/blob/master/dbaccess/uiconfig/ui/useradmindialog.ui although I'm not really sure how the second UI definition relates to the first (it seems to have a "reset" command, which I don't recall having seen anywhere in the UI). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #18 from prrv...@gmail.com --- That's what I wanted to know, it's better to say things clearly than to leave hope. Otherwise in the end, this bug tracker will lose all credibility and usefulness. If we want to solve this problem, does anyone have information concerning: - How to add a menu entry in Base under User Administration. - How to find the connection in the protocol handler which will manage this new url. Thanks. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #17 from Alex Thurgood --- @prrvchr: Basically, if you want something done in Base, you stand more of a chance of getting it if you do it yourself, or else hire someone to do it for you. Currently, I think it is fair to say that the database code is in a state of gradual semi-decline, with the occasional regression-fix made by some very kind volunteers. It is barely "hangin' on in there". Past experience of being a member of Base QA has shown that programming for the database module is a complex, and mostly, thankless task, as pretty much everyone who has been involved at some stage rapidly moves away to other (sexier?) subjects - as a case in point, the development to provide a functional embedded Firebird ODB and corresponding migration tool, which has essentially stalled. All coding contributors and efforts would be most welcome. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #16 from Robert Großkopf --- (In reply to prrvchr from comment #15) > Hi Robert, > > I hope this message, and all the others, should be read by the group that > maintains Base. There is no "group, that maintains Base". There are some people, who fix bugs. There hasn't been changed much in Base since LO exists. Firebird has been added as (experimental) internal database. Not much more … > I think the code needed for group management should be very similar to the > one already in place for user management. > > That's all that made me come here, but maybe I'm wrong? I don't know who created the user management. Could be it is part of LO and AOO for a long time. I didn't notice this management, because it isn't working with internal databases and isn't working with MySQL/MariaDB and also PostgreSQL. This bugtracker is the right place to ask for an enhancement. Some bugs will be fixed in a very short time, but an enhancement in Base … -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #15 from prrv...@gmail.com --- Hi Robert, I hope this message, and all the others, should be read by the group that maintains Base. I think the code needed for group management should be very similar to the one already in place for user management. That's all that made me come here, but maybe I'm wrong? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #14 from Robert Großkopf --- (In reply to prrvchr from comment #13) > > So I repeat my question, can we expect to see role management in Base. I > would clearly like an answer to know what to expect. Thanks again. Who should answer here? If you find a developer, who will implement this - no problem. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #13 from prrv...@gmail.com --- With the latest snapshot, jdbcDriver manages now read and write privileges (I just tested with HsqlDB and need to test with other) Any database administrator will tell you that privileges should not be assigned to users but to roles, which must be assigned to users. So I repeat my question, can we expect to see role management in Base. I would clearly like an answer to know what to expect. Thanks again. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #12 from prrv...@gmail.com --- > Base which displays it if the driver supports the com.sun.star.sdbcx.User > service Maybe Base only checks for the presence of the com.sun.star.sdbcx.XUsersSupplier interface? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #11 from prrv...@gmail.com --- > User Administration… couldn't size automatically and couldn't be resized by > user I have same issue an French UI: https://prrvchr.github.io/jdbcDriverOOo/README_fr#la-gestion-des-utilisateurs-et-des-privil%C3%A8ges-dans-base > The UI you have created with the extension shows that it can be done. This UI comes from Base which displays it if the driver supports the com.sun.star.sdbcx.User service, otherwise it displays an error message. Would be really nice to have the same for roles (i.e.: com.sun.star.sdbcx.Group), with the ability to add and/or remove users from the role. jdbcDriverOOo has com.sun.star.sdbcx.Group service already implemented. Although in the user administration the Privileges is read-only for the moment, the display takes into account the privileges coming from the roles of the user. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 --- Comment #10 from Alex Thurgood --- It seems that the UI elements are already there, but clearly, the underlying connections to the various different driver code have not been implemented: core/blob/master/dbaccess/uiconfig/ui/useradmindialog.ui core/blob/master/dbaccess/uiconfig/ui/useradminpage.ui core/blob/master/dbaccess/uiconfig/ui/userdetailspage.ui As I recall, OpenOffice.org (and StarOffice prior to that) had a user administration dialog for use with Adabas which was integrated into and shipped at the time with the office suite. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #9 from Alex Thurgood --- Nice dialog ! Confirming. Setting to RFE. Definitely nice to have, IMHO. Some would no doubt argue that it is not the role of an office productivity app to provide administrative functions for the database module, when there are specialized tools that already provide that functionality. No idea whether this would be an easy hack or not. The UI you have created with the extension shows that it can be done. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149926] Implement Role management UI in Base
https://bugs.documentfoundation.org/show_bug.cgi?id=149926 Alex Thurgood changed: What|Removed |Added Summary|Base manages Roles |Implement Role management ||UI in Base -- You are receiving this mail because: You are the assignee for the bug.
