Currently I'm accessing H2 Database in server mode and I use JDBC URL like jdbc:h2:tcp://localhost:8082/nio:~/source/database/database/ from my java application. By default, the user who accesses has the Read/Write access and I want to restrict it to read-only access.
I've come across the option ACCESS_MODE_DATA=r in the JDBC URL, which would make the H2 DB access read-only but the user who accesses H2 DB could bypass it, if he doesn't pass the option ACCESS_MODE_DATA=r .
Are there any alternate options to restrict the TCP connection to H2 Database as readonly ?