[h2] Re: SELECT command that returns a strange RESULSET

Newbie mistake, thank you Evgenij Ryazanov,, it took me a while to find the malfunction now I understand it. -- 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 h2-d

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

[h2] Re: SELECT command that returns a strange RESULSET

Hi! USER is not an identifier. It is a reserved word in the SQL Standard. It has exactly the same meaning as CURRENT_USER in the SQL Standard and in H2. https://h2database.com/html/functions.html#current_user -- You received this message because you are subscribed to the Google Groups "H2 Data

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

[h2] SELECT command that returns a strange RESULSET

Hi all, During my tests for the integration of H2 in Base, I unwittingly discovered a strange behavior of a SELECT command with an error on the column name. SELECT USER FROM INFORMATION_SCHEMA.USERS The correct column name is USER_NAME but this SELECT does not throw an SQLException and return

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

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