Re: Oracle Version 8 as read only

You can't.

Even if you were to set all possible tablespaces to READ ONLY, you'll find that it doesn't prevent folks from dropping objects.

All you can do is restrict people to schemas/accounts which do not own any objects and do not have permissions to create any. That way, you can restrict them to CREATE SESSION, ALTER SESSION, and SELECT permissions only.

on 11/26/03 4:44 PM, Browett, Darren at dbrowett_at_coquitlam.ca wrote:

> We are in the process of upgrading our peoplesoft app, using an oracle
> database of
> 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5
> database as readonly.
>
> I have read all the doc's but it appears I cannot open the database as
> read only. Looks like
> I could if the version was 8i.
>
> Does anybody have any pointers on how I could accomplish this.
>
> Thanks
>
> Darren.
> ------------------------------------------------------------------------
> --------------------------------------------------
> Darren Browett P.Eng This
> message was transmitted
> Data Administrator using
> 100% recycled electrons
> Information and Communication Technology
> City of Coquitlam
> P:(604)927 - 3614
> E:dbrowett_at_coquitlam.ca
> ------------------------------------------------------------------------
> ---------------------------------------------------
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).