Teradata: Select Table With No Lock
If those other users only need to Select from that table neither your nor the other session must add a LOCKING modifier.

A Select applies a READ lock by default which doesn't prevent other Selects, only INSERT/UPDATD/DELETE &amp; DDL is blocked.

If you want other sessions to be able to modify rows you should use LOCK ROW ACCESS which allows dirty reads, i.e. a 2nd session might modify data while you're reading.

Teradata supports two out of the four Standard SQL Transaction isolation levels, the least and the most restrictive:

Read Uncommited -&gt; ACCESS LOCK
Read Commited
Repeatable Read
Serializable -&gt; READ LOCK


Teradata 15.10 implements a new feature named Load Isolation which adds a kind of Read Commited.