Help - Query-Only Instance?

[heihojin]

I have been asked to reveiw an instance and provide scripts that will make it a query-only instance. How do I do that?

 

[fmorel]

You can alter tablespaces and make them read only.
(except temporary tablespace of course!)

syntax is
&quot;alter tablespace <tablespacename> read only&quot;

 

[Turkbear]

Hi,
In addition you cannot make the system tablespace read only
( For obvious reasons)..You may not be able to make the user's default tablespace read-only either, but I am not sure..It may depend on that user's rights..

 

[rcurva]

The following statement opens a database in read-only mode:
ALTER DATABASE OPEN READ ONLY;

You can also open a database in read-write mode as follows:
ALTER DATABASE OPEN READ WRITE;

However, read-write is the default mode.

If you want to co-exists both read-only users with read-write users on a same database, you can control it at tablespace level (as mentioned above) or at user definition level.
You can limit the quota of a user to a certain tablespace to 0 (zero).

ALTER USER scott QUOTA 0 on HR;


Robbie

&quot;The rule is, not to besiege walled cities if it can possibly be avoided&quot; -- Art of War