Oh, Sure.. I have seen that in the past (with 7.2.3.0). Actually, at my current job, we had one 'very special' database (built by an Oracle Consultant), where the Prod Schema owner was an OPS$ account. How conveeeeeeenient....! The Contractor DBA who managed it when I joined, told me that that Oracle password in the database for this OPS$ account was changed and it did not match the OS level password, so we were okay =:-O
In the months followed, we rebuilt the database... - Kirti -----Original Message----- Sent: Thursday, January 31, 2002 7:15 AM To: Multiple recipients of list ORACLE-L A user can be both, requiring a passwd and os authenticated. You can create a user identified externally then change its passwd. With this method, you have sqlplus client access requiring username/passwd and server access with no passwd required for cron jobs, etc. timp>create user ops$junk identified externally; User created. timp>alter user ops$junk identified by junk; User altered. timp>grant create session to ops$junk; Grant succeeded. timp>connect ops$junk/junk Connected. >From the server, log into user junk, set db environment, sqlplus / and you are in :) Not sure if Oracle intended for externally to work in both cases. Gene > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [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).
