Consider also using "ALTER USER xxx ACCOUNT LOCK" instead of changing the passwords...
on 11/26/03 6:49 PM, Browett, Darren at [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > ------------------------------------------------------------------------ > --------------------------------------------------- > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
