Re: Restricting Database modifications via sqlplus

qazmlp1209_at_rediffmail.com (qazmlp) wrote in news:db9bbf31.0501020223.23066e24_at_posting.google.com:

> 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?
>

RTFM http://downloadwest.
oracle.com/docs/cd/B10501_01/server.920/a96524/c23acces.htm#10422 Received on Sun Jan 02 2005 - 09:23:52 CST