Latest jdbcDriverOOo <https://github.com/prrvchr/jdbcDriverOOo/raw/master/source/jdbcDriverOOo/dist/jdbcDriverOOo.oxt> 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 seems normal because there is no default DBA system role. And this imposes in Base after the creation of a table, to use menu Tools -> SQL to manually execute an SQL command: *GRANT ALL ON "NewTable" TO SA* to allow privilege assignment by SA in the user administration GUI <https://prrvchr.github.io/jdbcDriverOOo/#managing-users-and-privileges-in-base> In fact it seems to me that it will be difficult to do without a default DBA system role... Le dimanche 4 septembre 2022 à 20:24:36 UTC+2, prrvchr a écrit : > 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 are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/e2142404-90e5-427c-ac48-563981acfb15n%40googlegroups.com.
