We help IT Professionals succeed at work.

How to convert a user to readonly mode?

sakthikumar
sakthikumar used Ask the Experts™
on
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?

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
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.