> >It used to be (Oracle 8.0.5 think) that if you >created a user identified by >external (i.e.) via the OS then the user name >begain with OPS$. and had to >be referenced as such > >This does not seem to be the case in 81.1.7 on AIX. > > >When did this change? > >John Dunn >Sefas Innovation Ltd >0117 9154267 >www.sefas.com
John, Older than that I believe. OPS$ has been around since at least Oracle 5 - and then the prefix was mandatory. It became optional with the os_authent_prefix (default "OPS$") parameter introduced circa Oracle 6. No problem I am aware of with 8.1.7. Check your init.ora file. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul 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).