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

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

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

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 ->