RE: OPS$

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: kirti.deshpande_at_verizon.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_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).