-
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
-
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;
Best wishes!
Dmitri
-
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
anandkl
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|