samedi 11 juillet 2015

How to lock a table?

In my software I've created a procedure for create a database. In this database is most important have an integrity of the all values. I created a procedure that allows the user to block the download of data and the consequent integrity. In this way the software is going to get a database in their entirety and with all the necessary data. The problem now is that this procedure needs to check if a variable in the settings has been enhanced, so even if you import the database intact, you get back the creation screen and download database as this variable has not been exploited . So I decided to put in a database table called "integrity", simply write it in this table if the database is intact or not. I need to block this table, that the user should not be able to change but must remain locked without the possibility of altering the values. Only the software can alter the values ​​of the database. I was thinking of access, then password and anything else to protect this table, but I do not think that this procedure might be successful because the application will have a public distribution and advanced users might somehow alter the database anyway. Is there a solution?

Aucun commentaire:

Enregistrer un commentaire