BASE How to create users with different access rights ? [SOLVED]

[mgl]

Hello,

Trying to grant different access rights to different users or admin.

Is HSQLDB able to handle this ?

Is it done in conjunction with the operating system users definition ?

Thanks in advance, Michel

[Ratslinger]

Hello,

You will not be able to do this with HSQLDB embedded. Upgrade to at least a split database (see →
[Wizard] Create a new ‘split’ HSQL 2.x database) or a server based database.

Edit:

Once you have chosen a database, all the information for rights (read, write, add, modify, delete, etc.) is in the database User Guide. Here, as an example, is the guide for HSQLDB v2.5.1 → HyperSQL User Guide.

This is independent of the operating system.

[mgl]

Many thanks @Ratslinger