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


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


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.


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.

Many thanks @Ratslinger