>> All the users can see the data but only one person can work at a time.<<

My guess would be that you can grant update privileges on the table to one user, and restrict everyone else to read only privileges. Your application level will have to handle logging on to the "updater" account. We never spend time on DCL, and try to everything in DDL and DML.