How can I make a derby data base for only two types of
users, (user1 and user2).
User1 has the power only to modify the data base
structure (create – delete tables) and nothing else. This user must no has
access in data of the data base. No one else except user1 must not see any
information of the structure of the database and any derby.properties file.
User2 he has the power to work only with the data into
data base (read, write, delete data rows inside the tables), but he has no any
access in structure of the data base.
Each user must he has the own key entry.
These two keys must store with cryptography in side of
derby database.
The database will be distributed with those properties and each holder will
always user2.
Along with the database,
extra will be given and a ready set
of sql queries, ready to run. So user2 can write
java programs linked to this database and perform the given sql queries.
The user2 should be able to change its
own key.
