Securing the resources from one user to other user
The software does not allow other users to perform operations on the resource that would adversely affect the depencies of the user owning the lock.
Share Lock
If a user locks a table in share mode, other users can only view the data. But cannot update or delete the records. If they try to do so there system will go hanging.
To release the lock give commit or rollback command, multiple users can place share lock on same table at the same time.
Exclusive Lock
Only one user can place exclusive lock on a table.
Share Update Lock
That will lock records that are to be updated.
.png)
.png)
