create user/role with read only access?

how do I create a user and give him only permission to do selects on tables but not allow him to change anything? I believe the select on any table permission allows 2 things I might not like.
1) select sequence.nextval from dual;

• changing a sequence to a new value might not be a desired permission 2) I believe I read that this also gives them the ability to use the lock table command which could cause trouble
  • the user wants to use MS Access as the front end to write reports so I was worried maybe Access could lock up the tables in some way I was not intending.

Any other possible problems?

Thanks in advance.

Rob Received on Tue Feb 27 2001 - 16:00:24 CST