Make read only database???

[jeyaseelan]

Hi All,

We are running a database ( 7.3.4).We have to disable users (100 users)dml operation on the database,But they can query the database.Is there any short way to make it .


Kindly Advice Me
Thanx
JC

[kgb]

I do not know exactly about 7.3 version, may be you can try:
ALTER DATABASE OPEN READ ONLY;
or
ALTER TABLESPACE accounting READ ONLY;

[anandkl]

Try to read on the "PRODUCT_USER_PROFILE" table.This table is updatable.This table is read each time a user starts a session and all the privileges listed in this table will be granted to the user.So just updated this table for all the users with only select privilages.This is a little tedious process but is very effective.

regards
anandkl