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