From 11g onward you can make a table read only SQL> select ...