[h2] Management of users, roles and privileges in LibreOffice Base

Hi all, I just finished the admin module allowing the management of users, roles and privileges in LibreOffice Base. This integration could only be done with the help of fredt from hsqldb.org who provided me with

Re: [h2] Management of users, roles and privileges in LibreOffice Base

On 2022/08/24 3:10 pm, prrvchr wrote: I just finished the admin module allowing the management of users, roles and privileges in LibreOffice Base. You are welcome to ask whatever questions you need to, and we w

Re: [h2] Management of users, roles and privileges in LibreOffice Base

Hi! On Friday, 2 September 2022 at 23:40:02 UTC+8 prrvchr wrote: > >- java.sql.DatabaseMetaData.getUserName() should return the user who >is logged in (current user). > > This method is implemented in H2 itself properly. You can also use standard CURRENT_USER expression in SQL. >-

Re: [h2] Management of users, roles and privileges in LibreOffice Base

Hi Evgenij Ryazanov, I am aware of the requirements for this integration into Base. Thank you for answering it, it will be good for the LibreOffice / OpenOffice suites and will make them a little less moribund... To get the list of users, I now use INFORMATION_SCHEMA.USERS table with the query

Re: [h2] Management of users, roles and privileges in LibreOffice Base

Hi, After consulting the H2 documentation , java.sql.DatabaseMetaData.getUserName() works if you provide a username on the first connection. I have no way to force provide a username during the Base connection wizard (File -> Ne

Re: [h2] Management of users, roles and privileges in LibreOffice Base

By doing a little more testing, I realize that the table INFORMATION_SCHEMA.TABLE_PRIVILEGES has no content... It seems to me that I am the administrator (the user who created the database), can someone confirm that this table is indeed empty? Thanks. -- You received this message because you a

Re: [h2] Management of users, roles and privileges in LibreOffice Base

Latest jdbcDriverOOo commit supports forcing uppercase names of users and roles when creating them. The fact that the INFORMATION_SCHEMA.TABLE_PRIVILEGES table is empty after creating a table see

Re: [h2] Management of users, roles and privileges in LibreOffice Base

Database administration is out of scope of the SQL Standard and there are no predefined roles is the Standard. In the Standard, every schema has an owner and this owner may perform DDL commands within this schema. Anything else is database-specific. In H2, the most of DDL commands require schem

Re: [h2] Management of users, roles and privileges in LibreOffice Base

Hi Evgenij Ryazanov, Le lundi 5 septembre 2022 à 02:34:42 UTC+2, Evgenij Ryazanov a écrit : > Database administration is out of scope of the SQL Standard and there are > no predefined roles is the Standard. In the Standard, every schema has an > owner and this owner may perform DDL commands wit

Re: [h2] Management of users, roles and privileges in LibreOffice Base

A question I forgot to ask: Can you confirm that the names of users and roles only support uppercase characters without double quotes in all the commands where they appear. Thanks Le lundi 5 septembre 2022 à 15:11:51 UTC+2, prrvchr a écrit : > Hi Evgenij Ryazanov, > > Le lundi 5 septembre 2022

Re: [h2] Management of users, roles and privileges in LibreOffice Base

For further clarification, I would like to confirm that for administration in Base of users and roles as well as associated privileges

Re: [h2] Management of users, roles and privileges in LibreOffice Base

> Can you confirm that the names of users and roles only support uppercase characters without double quotes in all the commands where they appear. It is possible to use unquoted (NAME), quoted ("NAME"), or Unicode (U&"NAME") identifiers for names of users and roles in H2, but these names are al