Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hello, i want to know what is the best process to do this:
I'm building an application that retrieve data from an SQL server.
I want to implement a multi user enviroment, but i got this problem:
I) I got two level of users, the database admin and the regular users.
II) The database admin, have high priority in the delete/update/insert records.
III) If i use the lock, for example a record 1 in the table TABLE1 is locked by a regular user, but if in the same time the database admin want to update data in record 1 on table TABLE1, he cant...thats my problem, cause if was a regular user to want to update that record and receive a message teel him that the record is lock, everything fine, but the database admin NEVER have to way for a record to become unlock.
How can i solve that issue?
Thanks All
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement