Re: Oracle Version 8 as read only

Consider also using "ALTER USER xxx ACCOUNT LOCK" instead of changing the passwords...

on 11/26/03 6:49 PM, Browett, Darren at dbrowett_at_coquitlam.ca wrote:

> Looks like that is what we will be doing, basically creating
> a generic user with read-only privileges. All the current
> users will have their password changed so they cannot access the
> system.
>
> Darren
>
> -----Original Message-----
> Sent: Wednesday, November 26, 2003 4:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Darren,
> Couldn't you just open the database with a user that has all the
> necessary privileges revoked?
>
> -----Original Message-----
> Browett, Darren
> Sent: Wednesday, November 26, 2003 3:44 PM
> To: Multiple recipients of list ORACLE-L
>
> 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).