• Locks are acquired by a SQL connection.

    If one connection acquires an X lock on a table that connection can still do a SELECT; it is just other connections that will not be able to SELECT against the table until the X lock is released.