os authentication

From: kommareddy sreenivasa <kommacnu_at_yahoo.com>
Date: Sat, 15 Feb 2003 20:48:41 -0800
Message-ID: <F001.0054EC15.20030215204841@fatcity.com>

Hi DBA's

Can somebody clarify the flwng:

DB: 9.x
OS: solaris 2.8

1.
To setup OS authentication we need to grant either OSDBA or OSOPER to OS account( OS oracle a/c)?

so that we can connect to DB as
sqlplus / as sysdba

and we dont require a password file for this. is this true ? or anything to be added this statement ?

2. If we are not using OS authentication , then we setup a password file (exclusive) and connect to database to do a startup, we issue

sqlplus sys as sysdba
passwd:

My doubt is, whether the above entry (password: verifies the sys password ( if yes, from where it verifies ? )

I connected to DB successfully using

sqlplus sys as sysdba

without giving any password. (it also accepted anything like abc, xyz, 123 etc.,)

I am not clear how this works ?

Can somebody clarify the above.

Thanks in advance,
Srinivas

---

Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: kommareddy sreenivasa
  INET: kommacnu_at_yahoo.com

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: 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). Received on Sat Feb 15 2003 - 22:48:41 CST