how to change to read-only at session level?

[qingbo]

A user has insert, update, delete privilege and he must keep that. We want to give him read-only privilege at session level? What is the easiest way to do that?

[dknight]

You want to give the user read only at the session level, but at what level will the user have the other privileges?

Please clarify.