A share lock enables other transactions to read but not change a database object.
Concepts of the Database System, SQL Locks
Database Administration, Analyzing Database Performance
Database Studio, Displaying SQL Locks and Displaying Information About Database Activities
Database Administration in CCMS, SQL Locks