From kimberly.smith@gmd.fujitsu.com Fri, 31 Aug 2001 10:43:50 -0700 From: Kimberly Smith Date: Fri, 31 Aug 2001 10:43:50 -0700 Subject: RE: [OPS$users] Message-ID: MIME-Version: 1.0 Content-Type: text/plain Of course you could leave your parameter the way it is and just create a user called production. I don't use the ops$ prefix on my externally identified accounts. -----Original Message----- Sent: Friday, August 31, 2001 11:00 AM To: Multiple recipients of list ORACLE-L Yes, set the "os_authent_prefix = ops$" in your INIT.ORA Yigal "Bartolo, David" wrote: > Hi all, > > Is there some db parameter I need to set to get the ops$ login to work? I > am using ORACLE V8.1.7 on a Compaq Tru64 V5.1 > I have created a unix user called production. I then created the user in > the database called ops$production. > > When I login as this user and try to go into SQL*PLUS I get an invalid > username/password error. > > I get the error if I type: > > sqlplus / > > or > > sqlplus > get the username prompt and hit enter. > > Thanks > David > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bartolo, David > INET: bartolo@USCOLO.edu > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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). ____________________________________________________________________ Get free email and a permanent address at http://www.amexmail.com/?A=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yigal Ran INET: ydran@usa.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: kimberly.smith@gmd.fujitsu.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).