Restricting Database modifications via sqlplus

We would like to allow only 'select' & 'desc' statements and to restrict 'insert'/'update'/'delete'/'drop' statements, via sqlplus prompt.

But, if the 'insert'/'update'/'delete'/'drop' statements are issued from the application during the runtime, it should be allowed.

Basically, we would like to prevent any Database modifications done by the users(via sqlplus prompt), on our test systems here.

How exactly we can fulfill the above requirement? Received on Sun Jan 02 2005 - 04:23:08 CST