I\'ve declared the following table for use by audit triggers: CREATE TABLE audit_transaction_ids (id IDENTITY PRIMARY KEY, uuid VARCHAR UNIQUE NOT NULL, `time` TIMESTAMP NOT NULL);
吴函 2021-03-31 07:23 哈弗H2这车个人开发者_如何学Go认为优点是车子性价比,维修保养便利性方面比较好,缺点是车子相对费油,车子动力性方面一般。许洋
I\'m trying to access my application\'s tables in Play! Framework,开发者_运维问答 but I can\'t find it using the console.
In H2, we can make reference to compiled method in 开发者_运维知识库java classes, and create alias in the database.
Could we limit a table right, so only user that created a record CAN update/delete that record? For example, table A (f integer).
Is it possible to log all operation on specific table? For example, any row insertion/update/delete are logged automatically. That log should only readable/writable by 开发者_运维技巧admin. You should
What is the purpose of this table? From it\'s name, could we assume that it lists all rights assigned to each user?
I do understand that H2 supports stored procedure/trigger/using java classes to ex开发者_高级运维tend the functionality.
Greetings, What is the meaning of database role in H2? Is it kind of rights or grants? Which approach should be used:
We are using Java + H2 Database in server mode, because we do not want users from accessing database file.