We help IT Professionals succeed at work.

How to convert a user to readonly mode?

sakthikumar used Ask the Experts™
How to convert a user a read only user, who is already having dml privileges?
Is there any single/multiple privilege , which if we revoke, we can make it readonly?

Or do we need to revoke all the table privileges given?

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
There is no 'readonly' mode in Oracle when it comes to users.

You will need to revoke the granted privs and leave only 'SELECT' on the specific objects.