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
I do not know exactly about 7.3 version, may be you can try:
ALTER DATABASE OPEN READ ONLY;
ALTER TABLESPACE accounting READ ONLY;
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.
Click Here to Expand Forum to Full Width